I'm pretty sure its possible, but I just can't think of how!

[mfearer94]

Alright, so basically I have one major table that includes every part number with some basic information. Then, I need other tables which will have more specific information for each part number. So my question is... how can I add/edit a part number in the major table and have that update in the other tables? I feel like an update query is not the answer.

P.S. My final goal is to have different tabs in a navigation form that have information from each table that can be edited and used for calculations. Any help is appreciated. Thank you!

[offie]

Why do you want it to update in the other tables? Maybe explain it a little better.

Ex: I have Main Table with fields: Item, Color, Description
And I have another table that give information on when an item is sold, TableSold, fiels: Item, AmountSold, DateSold, Customer.

You would enter data individually, it wouldn't make sense to automatically update TableSold with new MainTable entries if you haven't sold any of the new items.

If you enter the information into these 2 tables, later you can make a query that joins the 2 tables via the Item field.

In regards to navigation tables the thing you need to know is that to refer to something in a navigation form;
Use this for the main form
[Forms]![Navigation Form]![NavigationSubform].[Form]![Name]
And this for a navigation form inside a navigation form
[Forms]![Navigation Form]![NavigationSubform].[Form]![NavigationSubform].[Form]![Name]

[mfearer94]

Thank you very much for your response! Sorry for the vague description so I'll go into more detail.

What I want to have is a main table which holds all of the part numbers and their corresponding customers, suppliers, description, etc...
Then, I need another table for all of the labor costs, set up fees, and operations for each part number.
I actually need many tables for different processes that each part number is going to go through.

So what I eventually need is the user to create the part number in a form which would edit the main part number table which I have already done.
(Now the tricky part) Then, the user would be able to query for the part number for the navigation form and be able to edit all the information for each of the tables/different forms all for that one part number.

I hope that makes a little more sense. Thanks for your time.

I just thought about this idea, but it may make a lot more problems. What about having the minor tables be subdatasheets and linking the part number fields. Just a thought.

[mfearer94]

Alright, so I believe that I found out my own solution. In case anybody else needs to find the solution to this thread...what I'm going to do is link each table through subdatasheets and then I'll be able to combine them all together through queries which also allows me to show calculations.