Saving data in 4 different tables from 1 combo box

[jjake]

Hello,

I have a combobox on form1 that displays values from field1 in table1.

I would like to record the selection (Control Source?) in field1 from table 2, 3 and 4

Is this possible?

 

[plog]

Possible, but probably not god design. Why do you need the value in 4 different tables? Explain this data better. Maybe show your tables.

 

[jjake]

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?

 

[plog]

What is the structure of all your instrument tables? List the fields and their data types please.

If you can get these 4 tables into 1, your form becomes much simpler.

 

[jjake]

What is the structure of all your instrument tables? List the fields and their data types please.

If you can get these 4 tables into 1, your form becomes much simpler.

Yes i think i can do this. I thought it would be easier to keep track of, but this may be the answer.

 

[MarlaC]

Additionally, after you've combined those 4 tables into one, you should have a look at having the VesselID be the Master/Child link field between the form with the combo box for selection and the subform where the data is recorded. That will save it to each record automatically when you create a new record of your measurements.