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

[gammada]

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?

[omegagoh]

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?

[bcooney]

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?