2 tables

[sadie]

I'm using access 2000
I have 2 tables with client info and data (a lot of the info is duplicative i.e. name address etc)
How can I join these so that when I want to add a new client, I only have to add it once and the info goes into both tables. Is this possible

 

[Fizzio]

Rather than struggle with the current structure and get into bother with duplicated info, restructure your tables so that none of the info needs to be duplicated.
You may have to create new tables and append the relevant data to the new tables before setting your relationships.

If you need help, post the current structure of your tables like below

tblClients
------------
ClientID
ClientName
etc

someone will suggest an alternative structure.

 

[dcx693]

I'd agree with Fizio that in general, it's not a good idea to have two tables with information duplicated between them. (For example, if there is some disparity between the two tables for a client record, how do you know which one is correct?)

Is there a reason this data needs to be separated into two tables?

 

[sadie]

I have 2 tables because it was an excel file and I put the 2 sheets in sepatate tables to put it in access

 

[Fizzio]

It depends on whether you want to continue to use excel as it's current function or whether you wish to use Access as your primary data collection method. If access is the answer, simplify your data structure. You will have less headaches using access than excel for your data collection and storage.