How to Use Double Join and Add Data

  • Thread starter Thread starter doyle60
  • Start date Start date
D

doyle60

I do not understand why, in the query below, I cannot add data to the
number field SimFob.

This is a query with a double arrow join. I have done this sort of
thing before, but with only a single arrow join.
____________

SELECT OrderDetails.PO, OrderDetails.Counter, OrderDetails.Style,
SimulationDetailtbl2.SimFob
FROM OrderDetails LEFT JOIN SimulationDetailtbl2 ON
(OrderDetails.Counter = SimulationDetailtbl2.SimCounter) AND
(OrderDetails.PO = SimulationDetailtbl2.SimPO);
_____________

I'm trying to get a pop up form to show the same records as the
subform. But the user can add data to a field in the pop up.

The idea is that I don't want the user to have to retype the Key
fields. Why should he? I want them to come up already, even if the
Simulationtbl is empty. When he enters the data, the system should
also enter the SimPO and SimCounter.

But this doesn't seem to be working.

This is a hard thing to describe for me. I hope this is enough.

Thanks,

Matt
 
Matt,

Well, for one thing, I think you will need a Unique Index on the
combination of the PO and Counter fields in the OrderDetails table for
this to work. Is that what you've got? Maybe by setting them as a
composite primary key?

And then, I think any new OrderDetails record will need to be explicitly
saved before a corresponding SimulationDetailtbl2 record would be
editable via the query.
 
Thanks,
I understand what you are saying but it isn't worth the trouble. This
is a complex database already, 7 years in the making and using. I will
simply put the new fields on the same table and deal with permissions
(the reason for the separate tables in the first place) on the forms.
Thanks,

Matt
 
Back
Top