I have searched help and watched a few videos but still don’t understand/can’t get it to work
I have a form for collecting orders. It has Year, Make, Model columns (and many more)on the main tab of the spreadsheet. I want to create a separate tab with the data for Year, Make, Model info for the drop downs in my app. I don’t have different views. Just one form that has dependent questions. The others so far have few options and I have done Enum lists for these. The Make and Model columns will have many option and I want them to add things to them easily in the future so I want a separate sheet.
Can someone please help me with how to do this or point me in the direction of relevant info.