Jump to content

Using a Value List, how can I get more info same record?


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

Recommended Posts

  • Newbies

Am doing a ticket printing layout for one of my developments. One of the fields am using is "Title" that gets its information from a value list as defined in a relationship. Now, I want that just as the user choses the correct "title" it could also get the "price" info from the same record. How can I do this?

  • Like 1
Link to comment
Share on other sites

  • 2 weeks later...

Dear Gammada,

I suggest that you store all the titles and the respective price in a Table, then define a Value List with Title as the first Field and Price as the second Field.

Regards,

Omega Goh

Speedy Scaleable Solutions

Am doing a ticket printing layout for one of my developments. One of the fields am using is "Title" that gets its information from a value list as defined in a relationship. Now, I want that just as the user choses the correct "title" it could also get the "price" info from the same record. How can I do this?

Link to comment
Share on other sites

What is a ticket printing layout?

What are your tables?

Is Title a field in a line items table? Are you trying to lookup a price based on a selection of a product?

Do you have a products table?

Is your value list of Titles defined to be ProductID and Title, showing the second field, "Title," while storing the ProductID in the Line Items table?

Link to comment
Share on other sites

This topic is 4407 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.