Relationships when one field is an autonumber

  • Thread starter Thread starter TLC
  • Start date Start date
T

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