I 4 different tables with 4 different types of measuring instruments. Pressure, Level, Flow and Temperature
I then have another table (Vessels) with a VesselID that each instrument pertains too. Each instrument table has a VesselID field lookup.
I have a form with tabs, each tab for a different instrument type. The goal is to open the form, select a VesselID from a combobox that the group of instruments pertain too, then fill out the information on each tab for each instrument. Because each instrument type is saved in a different table I do not want to have to enter the VesselID 5 times on each entry plus the plan is to be able filter this form later from the VesselID on the main form which will then display the instruments for that particular VesselID.
Along with this I also have another problem of what if a VesselID has 2 different pressure instruments but only 1 temperature, would I need to copy subforms into the tabs rather then using the fields?