two primary keys with different sources

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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.
 
Back
Top