Producers to Cars is really a one to many relationship.
That is - One Producer will make Many Cars.
I suppose we should say Models rather than Cars though
that's not really important.
Make sure you have a unique primary key on each table - let
Access do it's own thing and put Autonumber PK's in. Next
add a Long Integer field to Cars call it fkProd and make it
a NON unique index. The idea is that the PK of Producer
will get copied to fkProd for each appropriate row in Cars
when a record is created.
Then set a one to many Relationship on those two tables from
the PK of Producers to the fkProd of Cars.
You'll probably need to write an update query to fill in the
fkProd's for Cars that are already there.
Good luck... :-)
--
Nick Coe (UK)
AccHelp v1.01 Access Help File Builder
http://www.alphacos.co.uk/html/acchelp
Download Free Demo Copy
---
"Matthias" <cl*****@hotmail.com> wrote in message
news:dc**************************@posting.google.c om...
Hello,
I created an Access database, with information about Cars
& Producers.
I've got two tables:
- Cars ( GOLF, Chayenne, Beetle etc...)
- Producers ( Volkswagen, Ford, GM, Porsche etc...)
My goal is that when I click in the 'table Cars' a Golf,
there
automatically is made a connection with Volkswagen. And
when I click
at Chayenne that there is established an connection with
Porsche
etc...
I hope anybody can help me with this problem.
Because I am new here I am glad with any feedback. And if
I am doing
something wrong I would like to hear it.
Thanks for any help.