Updating tables on the many-side?

[Benny Wong]

Hello All,
I am using Access 2000. I am wondering if it is possible to update data / import data into the database when the data is for both the one-side and the many-side of the database? If it is possible how can I do this? The tables are:

tblClient - one side
tblContactType - many side

Thanks for any advice or suggestions in advance.

 

[FoFa]

You are a little vague, what ties these two together? Something on the external files I hope?

If there is a key that ties the two files together you can use as a foreign key, then you should be able to import them right into each table. How ever since you are asking, I assume that is not the case.
So can you expand on what you have that 1> ties the tables together, and 2> ties the files together?

 

[Benny Wong]

Hello FoFa,
Thanks for your response. I basically have two tables. The tblClient on the one side and tblContactType on the many side.
Here is the table links that I have currently:

tblClient tblContactType

Client_id Contact_id
FirstName Client_id
LastName ContactType
Title
Organization
Alt1Address
Alt2Address
City
State
Zip

My question is if the client wanted to import data from Excel into Access, I know that tblClient would import fine but what about the tblContactType side? If I could import how could I do it?
I hope my question is more clear. Thanks for your continued response in advance.