Column referring to values in another column

How do I constrain a column so that the values in it come from values in another column?

Think of an employee database. If the first column is name and one of the columns is manager, how do I constrain the manager column so that its values come from within the set of names?

Ideally the manager should refer to the manager row rather than the manager name.

I couldn’t find a way to do this in coda. Creating a new table seems overkill.


Here’s one possibility:

1 Like