Drop Down choices from another table?
We are a manufacturer, and we're looking to track the materials used per job. We build custom closets, so each job could potentially have multiple rooms, each with a different material. I have created...
Forum Discussion
It sounds like you are on the right track. There is always a decision to be made between using a Text - Multiple choice field or just creating a table. I personally lean toward creating a new table. I only use Text - Multiple Choice fields for options that will never need to be modified (e.g. "Yes/No", "Male/Female", etc.)
As for getting the material to show up as a dropdown list in your Layouts table, you just need to reverse the direction of your relationship. It is possible for one material to be selected in many different layouts.
As for getting the material to show up as a dropdown list in your Layouts table, you just need to reverse the direction of your relationship. It is possible for one material to be selected in many different layouts.
Should i have both relationships, or just the one?