Forum Discussion
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
------------------------------
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
------------------------------
- NicholasNeilio2 years agoQrew Member
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__You2 years ago
Qrew Legend
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
------------------------------- NicholasNeilio2 years agoQrew Member
relationship with many to many table (order)
------------------------------
Nicholas Neilio
------------------------------