>In the Tasmanian Traders app that ships with
>VFP3.0, 3 of the
>tables in the orders form that I have a question
>are are the
>PRODUCTS, ORDERS, and ORD_LINE_ITEMS. When the
>user wants to
>add an item to the grid, they choose the product
>from the
>combobox. What if the user wanted to put in an
>item number and
>have the rest of the info from the products table
>automatically
>populate the grid, such as description, qty on
>hand, make,
>model, or whatever. You couldn't tie the
>controlsource of say...
>the "description" of the product to
>product.descrip because your
>users would be changing the master description,
>and it would be
>redundant to put the description in the
>ORD_LINE_ITEMS table. What if
>the product number they enter in is not in
>existence, could the
>system ask the user if they want to add one to
>inventory. I know
>that wouldn't make sense in this particular app,
>but it would in mine.
>Any specific details would be appreciated. My 3
>year old son is going
>through the "WHY" stage and I am going through the
>"HOW" stage!
Greg
One way is if you want to make additions/changes to data (ie: in a combo list) is to put code in the right click method that would bring up a data entry screen (original). The idea is to have only one place where data can be added/edited to a table.
HTH
Tom