Hi All, I am new to Access so I apologize if this seems obvious. I am presently in the initial stages of a database and would like to do the following. I have 2 tables one called suppliers with (CompanyName, Adress, Phone, Fax, Website etc...) The other tables is a contacts table (standard contact template table) Now what I want is the following:
I fill the info of one supplier in the table for "Company A" : CompanyName, Adress, Phone, Fax, Website
I then want to add a contact that work for "Company A" in the contacts table. What I want now is that when i enter or select "Company A" in contacts table that the other relevant information i.e (CompanyName, Adress, Phone, Fax, Website etc...) fills in automatically
How do we do this and does that interfere with normalization rules?
RThanks for your help