Updating multiple tables with one form? (1 Viewer)

[tmcgill]

Hello:

I have data that needs to be entered. It is the same data across 3 tables but only for the first three columns, then it is different. I can create a form for one of these but not for all three.

Any help?

 

[pr2-eugin]

Hello tmcgill... Welcome to AWF..

Your description suggests that you are having some design issues..

Avoid data redundancy. Ideally, a piece of data should be stored in only one place, so that
its value can never be ambiguous. When a value is needed, refer to the one place where it is stored.

So if they are repeated I guess they are not related either?

If you fix your table design by adding appropriate relationships you will be able to achieve this by using Main Form/Sub Form set up..

 

[tmcgill]

Let me get this right. I should make: LastName, FirstName in one table only. At that point I should refer to that table?

 

[pr2-eugin]

To give a definite Yes to your question, I would need to see the current table structure and relationship (if any exists)..

 

[tmcgill]

I have one contact table, and two others. all connected through employee ID. Which won't update either...