I am trying to create a database to allow our employees to locate artwork
for
4 different product types, silkscreens, metalphoto, labels, and misc.
The artwork physically resides in individual folders, in 4-drawer file
cabinets.
I have created a customer table from quickbooks im****t of Customer,
Contact,
Phone, Fax, and ProductID.
I was going to imput the artwork in a Product table, with the following
fields:
ProductID, Customer, Product Name, Drawing Number, Revision, DashNumber,
Serilized(Yes/No), and Location.
I want the employees to be able to query the artwork by Customer,
ProductID,
Part Number to find the location of said artwork.
The file cabinets will be labeled:
S=silkscreen -1 thru 4 (for the drawer)
M=Metalphoto
L=Label
M=Misc.
Any help would be greatly appreciated with proper relation****ps, forms for
data entry, query form, etc.
Thanks in advance.
|
