Create Default Settings

It is necessary to create a DefaultSettings table and store one record in it with the default settings. You can open the DefaultSettings form like this:

procedure Form1_Button2_OnClick (Sender: TObject; var Cancel: boolean);
begin
  if SQLExecute('select count(*) from DefaultSettings ') = 0 then
    SQLExecute( 'insert into DefaultSettings (id) values (1) '); // add record with ID=1
  DefaultSettings.ShowRecord('DefaultSettings',1); // open record with ID=1
end;

I'm not sure to where you want the default settings to appear, when creating new record? it seems your button on Form1 is just a Show Form.

Anyway, for further samples, you can have a global variable which will be available to all your functions/procedures within your script that will handle the defaults.

Hi Corey, Brian, Konstantin,

A different approach might be to simply hold a 'user default' field on each table where you want a default setting to be pre-set;  the default setting can be changed by the user. 
In the attached example, all new records take the user default settings, all existing records display the settings that were valid at the time they were created.
I'm not sure how often you envisage these default settings being changed (if at all) once they've been set but you need to exercise caution if they can be amended as it could get confusing with a mix of units.  Or do you plan to re-work all the old entries and convert them?
I'd also look at making use of parent comboboxes so that choices are more structured for the user.
I changed your project around a bit so I could more easily see what was happening but the principles are the same.
Derek.

Your solution is more elegant in terms of coding and queries. But in terms of data normalization, I would rather store references to values.

Thanks to everyone for your help and suggestions. I am new to MVD and not 100% up there with the the coding side of things possibly only at  2%, I have tried to implement everyone's suggestions but with out any luck as I mentioned I may have overcomplicated what I was after I have attached a simpler example. Thanks again to everyone for their time and suggestions.  I hope you can help thanks

Thanks Derek, once I get home from work this evening I will upload my actual project , and maybe you can also offer advise on saving three from as one record

Hi Corey,
There are a few different ways to do what you're after;  as always, I'd keep it as simple as possible.
Have a look at the attached as one option.
https://app.box.com/s/nf4yp6y3hqk5rw8tklz8nxfd2vayk3vi
Basically, I hold the user defaults (for temperature, wave height etc) in a table (userdefaults) and load these values in as global variables to the script.  Then, wherever the label needs to show the appropriate default value, it just loads it from the relevant variable to the label's caption (there's no need for different labels for each value).
I've amended your 'mensetup' form with the changes.  Rather than over-complicate it, it just allows the user to enter such values as they want as default and uses field 'hints' to guide the user accordingly.
With regard to 'watertype' and displaying / hiding options depending on whether 'saltwater' or 'freshwater' is selected, I think you should look to use 'parent combobox' functionality (part of standard MVD) rather than trying to achieve it in the script.  As I said in an earlier post, the more you can make your program 'data driven' the less you need to be scripting.
Derek.

Hi,
The easiest way is to put everything onto one form.
And the easiest way to do this is to use panels so that it still looks like you're moving between forms.
https://app.box.com/s/dzsahu20t5axne6cw4dn4s53zpbjpffj
In the attachment, 
1.  everything that was on 'NewFishingTrips' form has been placed onto Panel1 (simply 'select all' / cut / add an appropriately sized panel / paste everything back on).
2.  create two new Panels
3.  copy (in the same way as above) everything off 'Conditions' form and paste it onto 'NewFishingTrips' panel2
4.  copy everything off 'Fishcaught' form and paste it onto 'NewFishingTrips' panel3
5.  set panels 2 and 3 to invisible
6.  reassign your 'next' and 'back' buttons to make the appropriate panel visible / invisible.
If you overlay the panels, the effect is much like moving from form to form but now it's straightforward to save everything that is on all 3 panels with just 1 'save' button.
nb:  when you open the attachment, just increase the height of  'newfishingtrips' form and you'll see each panel overlayed - to access each panel, just use the 'bring to the front' or 'send to the back' options
I've moved the 'next' and 'back' buttons so that they are consistently placed but it's just cosmetic.
Derek.