Jamie,
If you have 3 tables and the keys looks something like this:
postingID
associateID
productID
Have you tried to make the source of the grid a SQL select statement like:
SELECT postingID, associateID, a.Name, productID, p.Name
FROM postings
JOIN associate a
ON postings.associateID = a.ID
JOIN products p
ON postings.productID = p.ID
If you do not want to see the foreign keys, leave them out of the Select statement or TableStyle/GridColumnStyles of the grid.
Kind Regards,
Mat
>I still can't get this working. This is such a common scenerio, or should be if you are designing your UI correctly, that there needs to be an example of this. The problem with the help file is that it always shows the foreign keys rather than the description from the foreign table. No user wants to look at a bunch of ID fields. This seems to be a grid problem since I have it working in the maintenance tab with comboboxes.
>
>Jamie