Jump to content

Relational List Problem?


DesignX
 Share

This topic is 5767 days old. Please don't post here. Open a new topic instead.

Recommended Posts

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.

Link to comment
Share on other sites

  • 3 weeks later...

This topic is 5767 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.