Multi-select text field with descriptions
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 - ...
Forum Discussion
MarkShnier__You
Qrew Legend
Qrew LegendThere 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
------------------------------
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 =
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
Are you asking how to limit the drop down choices for Food Items to just those for Food Type, say Main?
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. If so, then similarly make reports appropriately filtered and set the Form Properties to use those reports for the embedded report.
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------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
Are you talking about the drop down to select Food Items? 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
------------------------------