I am going through a thought process of designing this form:
Main Form containing 3 subforms (
Form1 contains Name and ID info (Driver)
Form2 contains Name and ID info (say Co-Driver)
Form3 contains Various Vehicle Information.
I have 2 tables this information would go into:
Table1: Name, Address, ID info
Table2: Various Vehicle Information
Tables 1 and 2 are "One to Many" Relationship
Next I have Table3: Will contain a combination of Form1, Form2, and Form3
Table3: Name(s) Driver1,Driver2, ID Info Driver1, ID Info Driver2, Various Vehicle Info for (both) Driver(s)
I wanted a way to just use Table1 and Table2 and pull that information later and combine those on a report that has this:
Driver's Name: Bob Smith and Joe Smith
Vehicle Info; Some Truck and Trailer Info
Driver1_Id Info: 123456
Driver2_Id Info: 456789
Didn't know how I could do this other than creating a 3rd table to create the data combined and later pulling that data into a report.
Table3 I would: Driver1_ID, Driver2_ID, Driver1_Fname, Driver1_LName, Driver2_FName, Drive2_Lname, Various Vehicle Info (several fields)
I would take the data on the form and save to two/three tables.
Or if there would be a better and more efficient way, please let me know,
All help is appreciated to do this right the first time.