Relational List Problem?

[DesignX]

I have checked all over this website and i cannot see to find the answer to my question.

I use Version 6 and i have made a few databases with relationships and all.

i have:

Orders

Customers

UPS

Now what i want to do is in the UPS database is make a dropdown value list that populates based on another dropdown list. (confused???) read on:

in UPS Database i click on CustomerNAme and my Values are a lookedup value from the Customers Database. THis works fine but what i want to do is populate the P.O.Number Dropdown list with only the values that are associated with the CustomerName that i picked.

example:

in UPS Database i Click the CustomerName DropDown and Pick Company A. In the P.O.Number DropDown i want to display on the Values related to Company A not ALL the Companies. the CustomerName DropDown Values are Stored in the Customers DB and the P.O.Number Dropdown Values i need to come from the Customers DB.

Can anyone Help me.

[DesignX]

I hate to bump this but i have upgrader to FM 8.5 Advanced and i am still having such a problem with the "subcategory" problem.

any help??