Windows 7 64bit 
Access 2010 64bit
I watched a tutorial on Dlookup and it was perfect for me to populate the address i need associated with the contact. I have a Company Table, Contact Table and a projects table. in my projects table i need to have Engineer Of records(company name) & it's contact (2 seperate look up fields that created a relationship), Also have the same set up for Architect, Fabricator and General contractor all with their own contact. When I create a form and use the said fields from the projects folder, then pull the address1, address 2, city, state, and zip it automaticly promts me to estabish a relationship which creates the exact same value for all Engineer Of records,Architect, Fabricator and General contractor.. I need to have this seperate but not sure what to do. AAAAA! Please help. I'm a bit confused on the over all management of my database..
Reply With Quote
