Hi all,
First time poster, big time access noob. Please be patient
I am playing around with access for the first time. I have been reading different articles on basic design principles, primary keys, foreign keys etc.
I am trying to make a super basic mock inventory management system. I am just a little unsure of what would be an ideal table design, what to set as my primary keys, and how to set up the relationships. At the moment, I have this:
The test scenario is as follows; There is a warehouse with tools/resources for staff. All items need to be cataloged and stored in the table 'TBL_Products'. Staff (TBL_Clients) can access these resources as often as they like, each item just needs to be checked out.
Ultimately, what is required is a table (or query???, or form???) that will show the current inventory, and another that will show what is checked out to who (current checked out inventory).
Any help or pointers in the right direction would be greatly appreciated.