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.

Jamie

>Jamie,
>
>Can you please give more detail on the problem you are having and what is missing from >the Developer's guide?
>
>If you are trying to edit the results of a SQL join in a grid, I still think a >properties tab is a better solution since you can set the binding of each control.
>
>Kind Regards,
>
>Mat
>
>>I'm having this problem as well, and I don't beleive the developers guide shows the >>answer. It simply shows the foreign keys in the grid.
>>
>>Jamie