Hello All!
I have a noob question that should be pretty easy for someone here I imagine.
I run a small computer repair shop and have decided to explore the possibility of using Access to track my Clients, Service Tickets & Invoices.
I have began working on some rough designs, but have a few general design questions regarding how to structure my tables.
I bill residential and business clients at different rates, and store different information on both. Some business clients have multiple contacts which I keep information on seperately, as well as their respective IT Assets. I also keep track of the businesses themselves for marketing purposes. In that regard I track things like primary industry and number of employees.
My original solution for this was to create three tables for Residential Clients, Business Clients, and Companies. I thought this would give me the most flexibility.
However, I get a little stumped when it comes to tracking service tickets and invoices from that point.
I would like to be able to look at all service tickets or invoices for a given client using a client ID, but I cannot figure how to manage this if I have clients stored in multiple tables. I would like for the client IDs to be uniform in format for simplicity but,... for instance, if I let Access do it's auto-number thing I could potentially have Business and Residential clients with the same Client ID.
Can I make Primary Keys on different tables unique among one another?
Or can someone suggest a better way to organize this data?