Only show values from a related record?
I'm trying to get my drop down menu to show only values of a related records. For example, if I have 2 feilds "State" and "City", When I select a State in the "State" field, I want the drop down menu for the "City" field to show only the cities that are related to that state.
Ive seen it done before, can anyone help please?
Check out this post which is very similar to your request, you just need to substitute ORDERS and SUB-PRODUCTS with STATE and CITY.
If this is unclear and you need any help just let me know.