two primary keys with different sources

N

nice

Can anybody help me?

I'm trying to retrieve information from a table whichis dependent on two
primary keys - CustomerID and ProductID. These two keys come from two
different forms.

I need to fulfill both customer ID and Product ID requirements at the same
time. Customer ID is only one, Product ID can be many.
 
M

Mike Painter

nice said:
Can anybody help me?

I'm trying to retrieve information from a table whichis dependent on
two primary keys - CustomerID and ProductID. These two keys come from
two different forms.

I need to fulfill both customer ID and Product ID requirements at the
same time. Customer ID is only one, Product ID can be many.
Click to expand...

If the tables are designed and used properly each record would contain both
Customer and product ID and you would use the report designer to group them.

You'll have to give us an idea of what you have before we can help more.

Normally there would be a products table, customer table, Invoice table, and
an Invoice line item table.
 
Top