Portal to display data from another FMP database?

[MicheleC]

Is it possible to put a portal in a layout in database B that displays data from database A?  I don't want the information to be editable from database B, just visible there.  To (perhaps) complicate things further, the data I want to pull in and display is stored as a repeating field in database A.

Possible or no?

[eos]

Add database B as an External Data Source to database A. Then you can add TOs of tables from A to the Relationship Graph of B, and treat these TOs (more or less) like internal ones.

[MicheleC]

Aha.  But what is a TO?
 

Update:  Tested with repeating fields, doesn't work.  Only the first value is displayed.  Workarounds?

 

Never mind.  Thanks

[IdealData]

You can specify the individual reps in the portal.

See the object inspector on the data panel.

The limit of course is the number of reps and the width of the portal.