I have a DB (for Supply and Distribution) that has been in use a short while but it has been decided that some extra data was needed. I developed separately another form that calculates costs and the sharing or allocation. Now I am thinking the best way is to have this new form as a Tabbed Form (have never used these before. The original form has three subforms so is quite busy. The Main form source is a table with only 15 fields. The new form has 28. Now the new form will have one record for every record in the Main Form. At first the existing records will have no data matching the new soooo
Questions: Should I put all the fields from the new forms (record souce table into the MainForms Record Source Table?
Should I retain the New Forms table and have both IDs on a one to one?
In the Join Properties Should the "Only include rows where thejoined fields from both tables are equal" be the option or maybe Option 2 All records from MainForm and those from NewForm?
and one more question
How can I put all the existing main from controls Including subforms into the New Tabbed Form (Page1)
Already tried cut and paste but it looks like I have a bit of work to do , tab orders all mixed up, all Event procedures not in the new page !! Although probably not as bad as it sounds just maybe there is a better way
Thanks any and all ideas welcome