Hello!
I am currently working on a database to be used for inventory purposes. I have 4 different categories of stuff (computer equipment, furniture, books, supplies)
So far I have made a table for each of these with an item number as the primary key as well as a table for department/department number and a table for item number/department number. (so that I can look things up by department or by item)
The problem I have run into is that the autonumber is creating a new item number only in each field respectively and not out of all of them (ex. there is an item #2 in computers and an item #2 in furniture) I need every number to be different. Any help would be appreciated.
Thanks.
I am currently working on a database to be used for inventory purposes. I have 4 different categories of stuff (computer equipment, furniture, books, supplies)
So far I have made a table for each of these with an item number as the primary key as well as a table for department/department number and a table for item number/department number. (so that I can look things up by department or by item)
The problem I have run into is that the autonumber is creating a new item number only in each field respectively and not out of all of them (ex. there is an item #2 in computers and an item #2 in furniture) I need every number to be different. Any help would be appreciated.
Thanks.