Search results

Thank you for all of your advice. Given the nature of my job, I am now finally able to get back to my database design. As you all can tell, I am new to this. I'm trying to do things the right way, rather than treating Access like a larger version of Excel. Anyway, I've done what was...

Thanks, Niniel. I removed the primary key from the other tables but kept it on the "lead" table. Which now begs the question, how do I create a foreign key? I tried to keep the database struture simple. For example my lead table is has general information about the store. The other tables...

Hi. I have several tables that have the same field in each of the tables. For example, I have a store number that is present in each of the tables. The store number field is the primary key for each of the tables. How can I populate the store number in one of the tables and have it feed the...