Hello!
This might be a pretty dumb question, but so lets say I have a table called Courses and another table called Faculty, and each course has a Director & Coordinator, both of which are options from the Faculty table.
What’s the correct way to have two columns on the Courses table be selectable values from the Faculty table? Do I just make both of them select lists with the options being the faculty table?
Just create two columns, each of which is a relation column to the Faculty table.
Thanks for the response. That makes sense to me, but is it best practices to have multiple relation columns pointing back to the same table?
I don’t see a problem with that. Coda is not going to get confused; we (humans) will get confused LONG before Coda would. As long as you have your design documented so that you can remember in two years time…