AnsweredAssumed Answered

Conditional Value List from Multiple Tables??

Question asked by SlicChic on May 18, 2014
Latest reply on May 20, 2014 by SlicChic


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:

     Students ---<Enrolments

     Students ---<Books

     Students ---<Payments

     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?