S
Sacred
Hi,
I'm trying to build a database system for monitoring and recording the
following:
Customer details,
Items ordered,
Item sent,
I’ve set up the tables for the first two. Here’s my problem, I want to be
able to make a query that will allow my to query my customers, once queried
it would need to show both the customer information and their order
information (bearing in mind they may have more than one item and each item
is customer specific).
Currently I’m using a barcode scanner and software so that each order can be
stamped with a barcode and as its sent it can be scanned (this would fill in
information into a query (parameter) and then give me results. (basically
the software makes labels from anything in the database and the scanner
replaces keystrokes)
How do I set up the tables, relationships and queries so that I can run a
search for 1 customer and view their details and all of their orders at the
same time.
(I'm not some Access expert so basic explanations would be very helpful)
Regards,
Sacred
(Need further explanation just ask)
I'm trying to build a database system for monitoring and recording the
following:
Customer details,
Items ordered,
Item sent,
I’ve set up the tables for the first two. Here’s my problem, I want to be
able to make a query that will allow my to query my customers, once queried
it would need to show both the customer information and their order
information (bearing in mind they may have more than one item and each item
is customer specific).
Currently I’m using a barcode scanner and software so that each order can be
stamped with a barcode and as its sent it can be scanned (this would fill in
information into a query (parameter) and then give me results. (basically
the software makes labels from anything in the database and the scanner
replaces keystrokes)
How do I set up the tables, relationships and queries so that I can run a
search for 1 customer and view their details and all of their orders at the
same time.
(I'm not some Access expert so basic explanations would be very helpful)
Regards,
Sacred
(Need further explanation just ask)