Yes it is possible do fill in many values based on one value. You can have a
function on a field which returns a value when some other fields value is
changed.
In the control where the initial value is entered click on rules, then set
the condition so if a particular value is choosen the rule will be applied.
Then Click on Action, and you can select to enter the value of another field.
Then choose the field (i.e. Price) and enter the value.
> Yes it is possible do fill in many values based on one value. You can have a
> function on a field which returns a value when some other fields value is
[quoted text clipped - 6 lines]
> > up the form to allow a user to enter many item numbers. Does anyone know how
> > to do this or is it even possible. Thanks!
Miss Piggy - 27 May 2005 16:54 GMT
I forgot to mention that I am connected to a data source and I want the form
to allow users to enter in item numbers, and then the form should populate
the fields with the data for multiple items. here is a sample of what I am
trying to do...
ex. enter item # (box would be here)
enter item # (box would be here)
" "
output would be:
headers: item # Price location
item# price from DB location from DB
item# price from DB location from DB
item# price from DB location from DB
like i said before, I was able to do this for one single item, I am not sure
how to do this for multiple items. Your output is greatly appreciated. thanks
> In the control where the initial value is entered click on rules, then set
> the condition so if a particular value is choosen the rule will be applied.
[quoted text clipped - 11 lines]
> > > up the form to allow a user to enter many item numbers. Does anyone know how
> > > to do this or is it even possible. Thanks!