Multi-select text field with descriptions

Question

Two tables, using made up info as example to simplify question.
1st table - Main
Customer Name - Text Field
Burger Selection - Multi-Select Text Field
2nd Table - Definitions
Burger Item - Text
Burger Description - Text - Multi-line

Hamburger - Fresh, hand-formed patties hot off the grill and placed on a soft, toasted sesame seed bun.
Cheeseburger - American-style cheese melted between fresh patties and placed on a soft, toasted sesame seed bun.
Question: On Table One, when the customer is selecting the burgers, I want to be able to show the description on the form so they know what the options are.
IOW - how can i show descriptions of the options in a multi-select text field.

------------------------------Nicholas Neilio------------------------------

MarkShnierYou · Answer

There is not an elegant way to do that with a multi select field. have you considered a middle join table where 1 Order has many Order Lines and One Parts Master has many Order lines. The order lines can hen have lookups for the descriptions and also data entry fields for the quantities and perhaps prices or price overrides.

------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------

Sign up

Login to the community