Georges,

I'm assuming both ID numbers in these Tables are the Primary Keys and
Referential Integrity Is Enforced on CarID

I'm assuming also something like this;

"SELECT Brand, Price, Extra
FROM tblCars INNER JOIN tblExtras ON tblCars.CarID = tblExtras.CarID"

If you are attempting to enter data in this Query, you are tring
simultaneously trying to add new rows to both Tables. What you want
to do is add the car and it's price once, then add multiple extras.

The simplest answer to this question is to keep these separate. Try
opening up tblExtras in design view, click the CarID Field, then
select the Lookup Tab, choose Combo Box under Display Control,
Table/Query as Row Source Type, "SELECT CarID, Brand FROM tblCars
ORDER BY Brand" as Row Source,Bound Column = 1 and Column Count = 2
(there is a better way to display the data, but I can't quite think of
it right now)

Now just enter data directly into tblExtras or create a Form with both
Tables displayed to enter data as you wish

HTH
russ

Though of course ExtraPrice might end up in the junction table.

"Mike MacSween" <mike.macsween.damnthespam (AT) btinternet (DOT) com> wrote