I have a data set that links to another dataset through a multiple item reference. One a formula data set and one an ingredient set. I need the ingredient items to appear in the order that I enter them into the multiple item reference field because they need to be displayed in order of weight as a part of an ingredient table. Many of the items are repeated over several formulas so I am not able to sort the ingredient data set in a way that matches every formula. What are my options here for defining, per formula, exactly what order the referenced items should show up in?
Is there an option to have the ingredient dataset NOT sorted at all? Currently, it is set to sort by date created. If I could take that option out I would imagine it would sort by the order they are entered in the reference field, but I do not see a way to remove all of the sorting options. Once one is removed, the default "Date created: New -> Old" shows up again.
Thanks for the help.