newbie in operation in here; so please be patient with me.

i have three tables in a database (version 8.0.2 advanced on osx). i am
building a layout where two dropdown will be listed. the first one, load
values from let's say table1. these values are not indexed. the indexed
values corresponding to the dropdown values are loaded in a separate
text field to the side. so far, no problemo!

however, i'd like to load values from another table, let's say table2,
that are also not indexed into another dropdown field. these values will
be based on the value of the text field related to the first dropdown.
conceptually, i need to pass the values of the text field to the
database so that it can pull the values for my second dropdown. how do i
do this?

thanks,
lark

In article <l%D7i.9684$4Y.6200 (AT) newssvr19 (DOT) news.prodigy.net>, lark
<hamzee (AT) sbcglobal (DOT) net> wrote:

By the sound of it you have one field (PopUp_1) formatted as a pop-up
menu / list that pulls it values from Table_1. A second field (Text_1)
then uses auto-enter or a calculation to give it data based on the
value chosen in PopUp_1. This you say works.

You now want a second field (PopUp_2) formatted as a pop-up menu / list
to retrieve its possible values from Table_2 based on the data in
Text_1.

This is fairly easy to do. Table_2 needs to contain records for every
single possible combination of Text_1 data and PopUp_2 values.
eg. In table two there must be at least two fields:
Text_2 Value_2
Record 1 Rodent Mouse
Record 2 Rodent Rat
Record 3 Feline Tiger
Record 4 Feline Lion
Record 5 Fish Trout

In the original table you have to create a Relationship that links to
Table_2 using the data in Text_1 to match with Table_2's Text_2 data.
eg.
rel_PopUp_2 Show records from Table_2
when Text_1 = Table_2::Text_2

You can then create a Value List that obtains it's values via this
relationship from Table_2,
eg.
vlist_PopUp_2 values from field rel_PopUp_2::Value_2

and format the PopUp_2 field to use this Value List.

Now when the user choose a value in PopUp_1 that causes Text_1 to be
calcaluted / auto-entered as "Feline", PopUp_2 will display the
possible choices as only Tiger or Lion (actually they'll display the
other way around since they are sorted alphabetically).

BUT there will be a problem if the Text_2 field in Table_2 is a
Calculation field since you relationships don't work when the
child-side is a Calculation (it can't be indexed).

Helpful Harry
Hopefully helping harassed humans happily handle handiwork hardships ;o)

In article <l%D7i.9684$4Y.6200 (AT) newssvr19 (DOT) news.prodigy.net>
lark<hamzee (AT) sbcglobal (DOT) net> wrote:


Matt

--
I'm trying a new usenet client for Mac, Nemo OS X.
You can download it at http://www.malcom-mac.com/nemo

In article <l%D7i.9684$4Y.6200 (AT) newssvr19 (DOT) news.prodigy.net>
lark<hamzee (AT) sbcglobal (DOT) net> wrote:

See Dynamic Valule List Demo at http://www.VirtualVermont.com/FMP

Matt

--
I'm trying a new usenet client for Mac, Nemo OS X.
You can download it at http://www.malcom-mac.com/nemo

Helpful Harry wrote:
This is helpful, Helpful! I'll have a look at it tomorrow at work and
let you know.

thanks