Dear sirs,
I describe my problem with a simplified two-tables model. These are not the real ones, just an example to show you the issue.
Suppose you have a products table (product id, description, unit of measure, unit price, available stock), and an orders table (product id, order quantity). I don't mention order id, customer id or other obvious fields because they doesn't matter by now.
Suppose you are in the orders table ADD form or EDIT form. Editable fields are product id and order quantity. First you select product id in a drop down list (look up wizard showing product id). Once selected, and just below the product id field, you want to view the respective description, unit of measure, unit price and available stock before you enter the quantity. The problem is that these four descriptive fields need to be not editable, i.e. the user may only read them. And, of course, if in the same form the user changes to another product id (no matter the quantity value), the four fields update automatically (I guess by means of Ajax). Suggested form could be:
product id (editable)
description [color="#808000"]XXXXXXXXXXXXXXXXXXXX
unit of measure
unit price [color="#808000"]9999.99
available stock
order quantity [b][color="#006400"]9999 (editable)
Which is the best advice or technique you recommend me to achieve this issue? I use a PostgreSQL database and (for now) PHPRunner 5.2.
By the way, I know I have the look up wizard tool "This dropdown is dependent on...", but this forces the dependent fields to be editable, and this is just what I want to avoid.
Just as a comment, I manage huge PHPRunner projects, so I can't migrate them to a newer version in a short time. But tell me if the problem I showed above is solved in newer releases of PHPRunner.
Thank you in advance.
Best regards,
DrGregory
