Create a repeated lookup
Posted on 2006-06-22
this is quite a complicated one I think...
I would like to create a form that can perform multiple lookups.
Here's how I would like it to work.
Field 1: Text field - editable
The user types in a value
Field 2: Text field - Computed
This performs a lookup on Field 1 to view 1 and returns multiple values.
Here comes the tricky part....
Field 3: Text field - Computed
This performs a lookup on each value in field 2 individually and returns multiple values
and so on.
Any words of wisdom on this please?
I am thinking I will need to create fields dynamically somehow?