Form to enter data for simulation without saving ???

[goepf]

Hi

I would like to use a form to have a user simulating planning data (see attachment)

the articles and price per planning unit is coming from a query and the user should be able to enter a qty to calculate the value (price * qty). As the selection of SKUs will show several SKUs (5-20) where the user should "choose" the ones where to simulate, I used a cont.form to show the SKUs - but as the 2 field (qty, value) are not in a table (should be "unbound"), they are not individual to each dataset - and updating one will change all other fields...

is there a simple way to enter data in a form without keeping it for later use and without linking it to a specific table?

Thanks for your help!

Goepf

 

[pbaldy]

You could bind the form to a "temp" table, which need not actually be temporary, just not the actual data table. That will allow you to have multiple records for your continuous form, but not actually save the data. You could empty the table either when loading or unloading the form.

 

[Epic]

nothing is simple... as Paul suggested you should create a a teble for temporary operations then save the data source sql in a string variable alter it as necessary then anytime you need a simulation just replace the data source of your form with the string you have modified.