linking parameters 1

[hencyt]

I need to create 2 parameters that will need to be "linked" together; for use in later queries and forms.

I need the user to be able to enter a list of item numbers and quantities. But I need to know which item number goes with which qty.

How can I prompt the user for these values and keep them straight in the db to use in equations?

Thanks in advance,
SunnyD

 

[SeeThru]

Ummm.....

1) save them to a global static variable array

2) save them to a temporary table using a bound form

3) have them on an unbound form an refer to the form

3 is simplest, 2 is often more useful, 1 I have never really tried

 

[hencyt]

SeeThru,

Thanks for your suggestions. One other thing I forgot to ask before. The user needs to be able to enter an unlimited number of items and corresponding qtys. They probably won't enter more than say 20, but they may enter as few as 1.

How is the best way to handle that?

Thanks again!
SunnyD

 

[SeeThru]

Id say use a bound form, bound to a temporary table. You can use one record (row) per pair of criteria. Leave the form open in the backgroud, or to be on the safe side set form.visible=false (you can make it appear again as well).

Once you have done with the information, use a runSQL for

DELETE * from mytable

to clear the temporary table, and requery the form to blank it. You may wan to run the delete query on database open to make sure nothing is left if the user quits unexpectedly.


The information entered in the form will be avaialble programtically - open a recordset for the table the form is based on. You can step through the recordset, using each record in turn.

 

[hencyt]

Ok I will try it. THANKS for your help!

SunnyD