Jamie,

Sorry for the slow reply, I was on vacation all last week.

Are you using the same data source on the properties tab? In this scenerio, I would use a SQL to join the 2 or 3 tables and display the results in the grid. Once you click on the Properties Tab, you could have seperate business objects for each table that query a single record. After an edit, you can then call the save method of each. I hope this helps.

Kind Regards,

Mat


>Hi Mat,
>
>Here is the scenario and I think it would be pretty common. I have three tables with two that are parent tables (Associate and Product) to the third (Posting). Thus I have a child table with a primary key (postingID) and 2 foreign keys (associateID and productID).
>
>When I go to edit the Posting table I want to see the Associate.name and the Product.name in the grid as well as in the properties tab. In the properties tab I have it working for display purposes using two combo box controls. However, even there I get an error about saving a null value to the associateID field (foreign key) in the Posting table. I can't get it working at all in the grid control.