Search results

Yep, I was able to talk to my husband (computer engineer) after work and get some input on this. He suggested the same thing. Think I have found what I was after, thank you for your input.

There are multiple reasons that they need to be separate. I just need to know if/how I can ensure that a customer ID entered into one table is not duplicating a customer ID in the other.

Each table contains nearly identical fields, but there are issues such as allowing people access to only domestic information that require the tables to be separate. Previously, my primary key was the customer number. That is still the case once international and domestic were split, but I just...

Hi All, Access newb-ish, I've worked with the basics for several years but recently got upgraded to 2007 so I'm having to re-learn some stuff and learn more about creating a database now that I'm needing to do that instead of just enter data and run queries! Apologies in advance for what I'm...