Peter,
>In the Jump Start, the OrderDetail datagrid does not have a column ProductName to describe the product. From a user point of view, the ProductID does not tell them anything. I think a ProductName column is needed.
>
>I want to add this field to the datagrid, and pull the information associated with the ProductID. Data in the datagrid is begin added in two phases. The approach should handle both of these cases: Data being pulled from the table and data being added as a new row.
>
>What is the best approach to handle this? Thanks ahead for the tip.
I recommend adding a combo box to the DataGrid for the Product Name. The selected value can be driven by the foreign key in the OrderDetail table and you can fill the combo box with a list of product names.
Best Regards,
Kevin McNeish
Eight-Time .NET MVP
VFP and iOS Author, Speaker & Trainer
Oak Leaf Enterprises, Inc.
Chief Architect, MM Framework
http://www.oakleafsd.com