Updating database ??

[BennyWong]

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.

 

[Transcend]

Hi,
i'm still not quite sure what it is you are trying to do?
Could you explain it more?
Yes it's possible to update and import data when there are one to many relationships ... ?

Transcend
[goregous]

 

[BennyWong]

Hello Transcend,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
etc.

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 being the many side? If I could import how could I do it?
I hope my question is more clear. Thanks for your continued response in advance.

 

[Transcend]

Hi there

basically because tblContact_type contains ClientId's from tblClient, you will have to import ALL of the Client table before the contact type table.

Once you have imported all client records there should be no hassle importing the contact type table.

However another way to set up your database would be

tblClient tblContactType

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

That way you have your contact type table with all the different types. And then a contact type id in your client table which references it. If this is the case, you would need to import all the contact types FIRST. However if you don't want to change your structure, import the clients first.

Hope this makes sense

Transcend