i've basically got 2 tables, table1 with 2 columns called "OrganisationName" {PK} and "ContactName". table2 has 3 columns "OrganisationName" linked to the 1st table, "ContactName" also linked to table2 and "PhNo". i've created a form with txtboxes "table1.OrganisationName", "table1.ContactName" and "table2.PhNo". what i'm after is that everytime i add something to table1.OrganisationName, it gets added to table2.OrganisationName as well. same with "ContactName". i can't seem to do this even though the tables are linked together. how can i do this through a form?

In a database it is best not to store duplicate data which is what you are doing by having the same field data in both tables, why don't you just store all your data in one table? M

i have simplified my example, my actual database has other attributes and data linked

What do you mean the tables are 'linked'? If you mean a lookup column, then that does not automatically add new data in the first to the second. If you have a one to many situation, say several contacts for one company, there are a number of approaches that can be used, but on a Outlook form these will be limited, and I haven't worked with them enough to be sure what will work and what won't. Basically you either have to have code that will return the new identity field of the the 'one' side, the company, and then add that with the contact info to the contact table, or have the user save the form (could be automatically when they go to a second form), and reload the customer table so there is a choice of selecting that new customer in an Add Contacts form. Peter (Alert me if you want a reply)