I am attempting to display information from Database B in a form within Database A in a Matrix object. In database A, I selected database B from the popdown in the Matrix/Data panel. I used the Create Frame Object. Within that frame object, I dragged a Text Display Object. Selecting that object, and using the Formula panel, I enter a formula of “Field: “ +«FieldB». (FieldB is a field in database B.)
The result in the Matrix Frame Object is “Field or Variable [FieldB] does not exist.” Nothing displays in the Matrix. If I choose the ‘Pass Thru’ checkbox, all matrix rows then display that same error message.
(I’ve reduced the number of records in database B from 76,000 to 12 due to the fact that when the larger number of records existed, I had non stop beach balls. I’m hoping that when the Matrix Object is working correctly, that the larger number of records in database B will not be a problem. My end goal will be to display data from ~5 records that have a corresponding value in related records.)
I think what you’re missing is the entire documentation section that describes how to do this? The process for displaying a matrix using a different database is completely different than displaying data in the current database, so you probably can’t just “wing” it.
Ah. I did read the documentation 3 or 4 times. (I read it closely enough that I offered a correction when in one instance it stated ‘Matrix Object Frame’.)
When using the Matrix object, it becomes natural to know that the Matrix Frame Object is the key to making the Matrix work.
BUT… when using with an alternate database, the one time that the documentation states ‘Matrix Object’ while relating to a necessary formula with alternate databases, it does mean Matrix Object. Do not think that the word ‘Frame’ was left out by mistake. It really does mean that you need to work with the Matrix Object.
