Relationships when one field is an autonumber

[TLC]

I have a basic retail database, with tables Customers,
Inventory, Sales and LineItems (the products purchased on
a sales invoice). My CustomerID (found in Customers and
Sales) and my InvoiceNumber (found in Sales and LineItems)
are both set to autonumber on the one side. This seems to
be creating a problem when I try to create queries based
on a set of related tables - I get the generic mismatch
Join error.
The problem seems to be the fact that the one side is set
to autonumber, while the many side is not. I *can't* set
them to autonumber on both sides the way it is currently
set up, as that would make 2 autonumbers on Sales, which
it won't accept. Is there a way around this, or will I
have to manually create customer IDs and invoice numbers?

 

[Jonathan Parminter]

Hi TLC, I recommend that you open the sample database, c:\Program Files\Microsoft Office\Office\SamplesNorthwind.mdb (default location only). Examine the structure for ideas and answers

Luc
Jonatha

----- TLC wrote: ----

I have a basic retail database, with tables Customers,
Inventory, Sales and LineItems (the products purchased on
a sales invoice). My CustomerID (found in Customers and
Sales) and my InvoiceNumber (found in Sales and LineItems)
are both set to autonumber on the one side. This seems to
be creating a problem when I try to create queries based
on a set of related tables - I get the generic mismatch
Join error.
The problem seems to be the fact that the one side is set
to autonumber, while the many side is not. I *can't* set
them to autonumber on both sides the way it is currently
set up, as that would make 2 autonumbers on Sales, which
it won't accept. Is there a way around this, or will I
have to manually create customer IDs and invoice numbers