LinkedIn
Twitter
Hello All,
I have an issue I have been working on for a few days and keep getting stumped.
I have two tables 1) Cookie Cutter Inventory and 2) Orders.
I have a field in the orders table where I want the user to be able to choose from the list of Cookie Cutters in the Cutter Inventory. This is simple enough, but there are some additional criteriaโฆ
-
What I NeedThey need to be able to select multiple cookie cutters. What Iโve Tried: Tried a REF column but couldnโt choose more than one cutter. So, Iโve made the column an ENUMLIST with a ValidIf statement for the Cookie Cutter Inventory Table. However this only allows me to display either the cutter name or a photo, leading to requirement 2.
-
What I Need User to see both name and photo of cutter when selecting from list. The end result that is put in the field can be either just the image or just the text but I want to see both when they are choosing What Iโve Tried: ValidIf Statements work for one or the other but I canโt get it to show both. If I do text and a validif statement for the cutter name I get the name and the same for the photo.
3.What I Need A way to search the within the list when selecting an option. Some users may have hundreds or thousands of cookie cutters so scrolling through all the photos and/or names wouldnโt be as efficient as if I could start typing in the name and have the list narrowed down.
Iโll include some photos below! Appreciate the help!
