Form Help!

[matcrawf]

I'm working with a database, with two main tabs. Each tab, is running off a single table. (i.e., tab 1 is the main form and tab 2 is a subform).

Tab 1 - A form running off a general company information table. (main form)
Tab 2 - A form running off a contact details table. (sub form).

The overall point of the DB, is to track all involved companies, as well as their corresponding contacts.

When I add a new company on Tab 1, I would like that company information be added to each of its respective contacts.

So, I add Company ABC to the database and want to add John Doe as a contact. When I do so, I would like John Doe to be associated with Company ABC.

Any suggestions? Thanks!

[maxamis4]

Do you know how to create relationships within tables? That is the solution to the question you are posing right now. You want to have a primary key for company ABC. Lets say its 1, now in table_sales_Det ails you want to have a "One to Many" relationship to table company based on the foreign key (the field that relates to aBC). So what you have in the end is a field in your table that is call CompanyID, where all agents that that belong to that company have a 1 as the value to the first table. Lookup in google "Create relationship+Mi crosoft Access"

good luck

[MMcCarthy]

Have a look at this tutorial.

Normalisation and Table structures

[matcrawf]

outstanding. Thanks!

[MMcCarthy]

outstanding. Thanks!

You're welcome.