To accomplish this in FMP 6, I created a calculation in each database with the value 1. (User can't edit without much effort and all records match.)

Table 1: global_join = 1

Table 2: global_join = 1

I then set up a relationship between the tables using the "global_join"s and used that relationship for the portal. In FMP 7 this relationship set up isn't working.

In 7 I have an instance of "Customers" called Global Join connected to an instance of "Party" using the "global_join"s in each table.

The part that is confusing me is the portal shows one record but that record isn't the first record like one would expect. It only shows the SECOND record.

I've checked to make sure the relationship is going to the correct instance and I've made sure that all records have the "global_join" correct. I can't find anything wrong.

Here's the bottom line: I want to see all of the Customers' names through a portal in the Party table. I then have a button and script set up to add the customer to the Party. The button and script are working perfectly but the portal is not. Help!

Thanks!

Sabrina

You don't need a constant to constant relationship in version 7. Just match two fields based on the 'X' operator (Cartesian join), and all records will be accessible from every record in the other file.