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------------------------------

markshnier__you · Answer

There is not an elegant way to do that with a multi select field.&nbsp; have you considered a middle join table where 1 Order has many Order Lines and One Parts Master has many Order lines.&nbsp; 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------------------------------

nicholasneilio · Answer

Ok, next issue, change the setup a bit
1st table - Main
Customer Name - Text Field
2nd Table - Order(join table)
Order Date
3rd Table - Definitions
Food Type = (Main or Side)
Food Item = (Hamburger, Cheeseburger, Fries, Tots)
Food Description =&nbsp;
How do i Create a form that filters the definitions to the food type, so when filling out the order i have a section for each
thanks------------------------------Nicholas Neilio------------------------------

markshnier__you · Answer

Are you asking how to limit the drop down choices for Food Items to just those for Food Type, say Main?&nbsp;
If so you can make a report of Food items with a filter of Food Type = Main and then set the Form Properties to use that report for the drop down choices for Food Items.

Or perhaps you are looking to have multiple embedded child reports on the Parent Order record, and want the child records separated into sections.&nbsp; If so, then similarly make reports appropriately filtered and set the Form Properties&nbsp; to use those reports for the embedded report.

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

nicholasneilio · Answer

Not on the reports
on the order table, iow when on that table and filling in an order, first section drop down shows only the main's
then next section drop down only shows the sides.
------------------------------Nicholas Neilio------------------------------

markshnier__you · Answer

Are you talking about the drop down to select Food Items?&nbsp; Do you still have multi select fields or did you change to a relationship to get the descriptions?------------------------------Mark Shnier (Your Quickbase Coach)mark.shnier@gmail.com------------------------------

Forum Discussion

Multi-select text field with descriptions

Related Content

Checkbox Fields Vs Multi-Select Fields for Tracking

Summary report w/multi-select field

Multi-select field

Multi-select text field

Multi select field from another table