Complex Lookup

[gavinwebb]

I have a form which stores a value which it needs to lookup in another table.

The item I am looking up is organised in a two tier structure i.e. category table and a child item table.

I'm looking up the item from my new form.

What's the best way to do this?

In normal Clarion Windows I would create a lookup with two browses on it - one for category and one for table, link them and put a select on the child table.

[Bruce]

I think the Accounts example might be sort-of what you're doing here.

The idea is that you're selecting a "shipping service" - but the list of services you can pick from is limited by the "country" in which you will be receiving the item. So in this case the "country" is the "category" and the "shipper" is the child.

the way I did it in that example was to make the Lookup procedure a Form.
On the form is a drop-list (of countries) and a "shippers browse - as the country is changed, so the shippers browse is changed as well.
The shippers browse is in "lookup" mode so is ultimately the one which is selected.

This approach does depend a bit on having a limited number of "categories" - because it's a drop-down. Does this sound like it would work for you?

cheers
Bruce