Multiple tables to fill in one form

[Tcurtis]

Good Morning! I am trying to keep the number of forms I have down in my database. I have three tables that are exactly the same except for where the product is from. I am not using all of the fields for this printable form, just the ones that the user needs printed out. I plan on having three buttons identifying where the product is from on a chart. Each button will open a form for that product. How can I fill in one form from which ever table the user selects? I know you can use a form to fill in multiple tables but how do you do this in reverse?
Thanks

 

[revver]

If I understand you correctly, you want your form to display the sum of all three tables and then filter the data.

Why not have just one table with all the data in it. There would need to be a field to say where the product is from. This is the correct way to normalize. If you do this then all you need worry about is the filtering issue.

If you have a sound reason for departing from normalization rules then you can do one of these.

Base your form on a Union Query rather than any single table.
Have the buttons on your chart change the RecordSource to a single table when you load the form.

Base your form on a Union Query rather than any single table.
Have the buttons on your chart change the Filter properties of the form.

HTH

 

[Tcurtis]

Thanks for the response. I have a union query that will do the job, never thought about that. I had to depart from normalization due to user input from some of the data that is imported.