Dynamic Value Lists

[nbrown]

Ok, I have two databases. One database has two main fields I'm working with SERIAL_NO and OWNED_BY. In another database I have two drop down boxes one that displays all the SERIAL_NO's from the one database, and one that displays all the OWNED_BY from the other.

What I'm trying to accomplish...

When I select an "Owner" from the OWNED_BY box I would rather it show me only the 20-30 serial numbers in the SERIAL_NO box instead of all of them. Meaning, I only see the serial numbers for the given "Owner" instead of every serial number.

Can this be done?

Thanks in advance!

Nic

[andygaunt]

OK. Version 5.x onwards.

In your serial number valuelists, choose from field. But then choose only relating values.

Relate this from your relationships owner value list::owner. Then pick your serial number field.

This will conditionally change the serial number list depending on the owner.

HTH

[nbrown]

Worked great!

Thanks for your help.

Nic