Hi All,

I think this question will address a fairly general concern. It is similar to one I posted last week and that generated no response (thread 1000674).

I assume most of us have tables with FKs pointing to lookup tables. And when we present these records to the user for editing, we want to present the looked up values, not the FK themselves.

For example, in the MM Jump Start, we would normally show the ProductName in the Order Detail grid not the ProductID (looking up ProductName from the Product table). The question is how to do this?

I've tried playing with a view (e.g., SELECT [Order Details].*, Products.*
FROM [Order Details] INNER JOIN Products ON [Order Details].ProductID = Products.ProductID) but can't figure out how to get this to save after the user edits something in the Order Details record.

I wonder if there is a way to use a relation (like VFP SET RELATION TO) and I'm going to explore that today.

I'm new to MM and .NET, so even general suggestions would be appreciated.

Thanks in advance,