Adding info from other Tables

[squirell]

I have 3 Tables USERS, NT Info, PC. There are no Relationships between these tables ie
the USERS Table does not contain their NT ID or PC name.

My end goal is to have the USERS Table containing all information for a user from all 3 Tables.

I have a form that maps onto the USERS Table with a Combo Box for the NT id. When a NT ID is chosen I want to copy the NT info to the USERS Table and the same for PC Table.

I have been unable to get this working, any help would be gratefully received.

 

[kaspi]

Hi Squirell
I believe that you should consider creating the relationships between your tables rather then trying to put all data in one table.

Even if you do not imlement relationships you can look up the the value for Nt and Pc in combo or list boxes and write the appropriate data into existing fields in your user table.

Alternatively you just store Ids for NTs and PCs.

Good Luck

Jiri