The quickest way for an end user to enter values
Not a trick question this one... I have a scenario where end users are required to enter pricing data against 50 or so products which are common across our customers.
The products are set up in their own table. I'm wondering what the best way would be allow the users to type in the pricing information quickly and easily. I'm not going to have them go near an import routine!
The table where the prices go is not the same as where the descriptions are held (as both can change).
What would be the best way to 1) List out all the products from table A and 2) allow price updating quickly entering into table B). Both tables are related