Simple question from someone trying to grow their single-table
database into a multiple-table database.
I am building an inventory database.
It seems to me that I will create the following:
computer table
display table
scanner table
printer table
and so on…
Eventually I will create relationships between these tables, so that
I can show which devices are with which computers.
But that's not my immediate question.
Here is what I want to know first:
Each of these tables will have a serial number field for the devices
recorded.
Now, suppose I need to find the location of a device with a certain
serial number, but I do not know wether it is a computer, printer, etc…
How do I create a serial number field that will allow me to search
all of the serial number fields in all of the tables?
Or, can I use the same serial number fields in all of the tables?
Thanks,
b0b
--
Bob Sandkam
MacOS Support
Information Technology Specialist II
VCUarts Computer Center
School of the Arts
Virginia Commonwealth University
