Is this possible? Please suggest.

M

Mozart66

Hi,

I am developing a simple database that adds data and
prints requried reports. I have a table that has following
structure:

Product Code Text
UPC Code Text
Component Code Text
Pack Size Text
Lot #1 Text
Lot #2 Text

For each Product Code there are several UPC Codes. For
each combination of Product Code and UPC Code there are
several component codes. One component can be used for
several products or UPC codes. But for a given Product
Code and UPC Code a component is used once. See the
following sample data.

Product Code UPC Code Component Code
789
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Is this possible? Please suggest. 1
Look Up Value 2
This Is A Head Scratcher 5
Bill of material type query 3
Creating UPC Codes... 2
Barcode fonts with Add-In for Excel simplifies creation of multiplebarcodes 0
to data liste 1
link child field with master field using comma as a seperator 3

Top