Hi, I have a many-to-many relationship Users <<-->> Customers the join table is CustomersUsers I used to have it setup as just a join table and I worked the object graph to get stuff. I had a to-Many relationship from Users and a to-Many from Customers. I changed it and had EOModeler make a many-to-many relationship for me. That built the relationships I already had plus this interesting many-to-many relationship. So I start using it but it's not working. Here's some SQL that was generated. Notice that it tries to select a *nil* field SQLExecDirect in -[ODBCChannel evaluateExpression:(<ODBCSQLExpression: "SELECT t0.`Active`, t0.`CustAddress1`, t0.`CustAddress2`, t0.`CustCity`, t0.`CustCode`, t0.`CustCountry`, t0.`CustEmail`, t0.`CustFax`, t0.`CustID`, t0.`CustName`, t0.`CustPhone1`, t0.`CustPhone2`, t0.`CustPostal`, t0.`CustState`, t0.`EditDateTime`, t0.`EditUserID`, t0.`UserEditingID` FROM `Users` t2 , `!UserCustPriv` t1 , `Customers` t0 WHERE t2.`UserID` = ? AND t1.*nil* = t2.`UserID` and t0.`CustID` = t1.*nil*" withBindings:(1:2(UserID))>)] S0022-3903: [INTERSOLV][ODBC Paradox driver]Field not found: * I'm baffled. The reason I did this is because I need to insert records into the join table so that I can add and remove Customers from the list of customers the user has access to. I could just insert a record into the join table but I think EOF will do this for me. Any tips? And I want to say thank you to everyone. I'm really making a lot of progress here and everyone's been very helpful, esp. David Neumann. Thanks --Marc Respass
