Conditional Value List from Multiple Tables??
I'm looking for a way to have sales department information show up on payments records. Our db is based on students, and our tables are set up as such:
Both Enrolments and Books have the sales department codes. What I want is to create a record in Payments, and be able to choose the enrolment or book that this payment is for, which would then bring in the correct sales department codes.
I've been exploring conditional value lists for this, but can't seem to have a way of choosing data from 2 different tables... Would a script be a better option? Or am I missing something?