Hi all,

Trying to add a portal to one of my layouts and for the life of me can't get it displaying anything. Before I restarted the DB with proper key & foreign key fields it was easier!

Attached is my relationship table display.

What I'm doing is;

From blank layout (Layout setup - show records from COUNTRY)

Adding single field

Specify Field - COUNTRY:_kp_country_id

Inspector Data - Dropdown list

Values From - First Field: COUNTRY::Code, Second Field COUNTRY::CountryName

Show values only from second field

This setup gives me "This action cannot be performed because this field is not modifiable"

So changed Specify Field to - COUNTRY::Code

The dropdown list now works. (as it it shows the contents)

Adding Portal

Filter portal records - AIRFRAMES::country = COUNTRY::CountryName

Add a few fields into the portal from AIRFRAMES table

Nothing displays in portal, when changing the COUNTRY dropdown.

Any help/guidance most gratefully received.

Thanks

Dave

If you are on a layout of Country, you should not be changing any fields in order to select a country - just browse through the records.

If you do want to select from a list, you should be using a global field - but then you will need another relationship to match the global ID to the country ID in Airframes, and a portal based on that.

If you are on a layout of Country, you should not be changing any fields in order to select a country - just browse through the records.

If you do want to select from a list, you should be using a global field - but then you will need another relationship to match the global ID to the country ID in Airframes, and a portal based on that.

Hi, thanks for info, although still confused!

I'm not working on a layout that already displays COUNTRY fields, I created a new Layout and when creating new layout selected "Show records from COUNTRY", gave layout a name and selected layout type as Blank.

Then added the one field from COUNTRY into field to create dropdown list of current countries in Country table.

And then created portal as described above.

Had a look at Global Field storage, just not sure what to do there and when it said "Turning global storage on or off will cause all existing data in this field to be lost. Proceed anyway?" I quickly said cancel.

Silly think is before I redid the Solution with PK & FK and only used the data fields it worked!

I'm not working on a layout that already displays COUNTRY fields

It doesn't matter: if you are on a layout of Countries, you are browsing the Countries table. Any field (from the current table) you put on the layout belongs to the currently browsed record. If you modify that field by selecting from a list, you are modifying the current country record.

It doesn't matter: if you are on a layout of Countries, you are browsing the Countries table. Any field (from the current table) you put on the layout belongs to the currently browsed record. If you modify that field by selecting from a list, you are modifying the current country record.

Thanks comment,

I can now understand why I had a few strange changes to the data when I've been trying to work this out.

Can I be a pain and ask what (in real basic steps) do I need to do as to achieve something like the attached.

Sorry to being so noob like, but have to say I am. (ex average MS Access user, now Mac/Filemaker)

many thanks if you can assist further

Dave

Edited June 2, 201015 yr by Guest

I believe the simplest way to achieve this is to add a global gCountryID field to the Country table. Next, add another occurrence of Country (say Country 2) to the graph and link it to Country as:

Country 2::gCountryID = Country::_kp_country_id

Now create a layout showing records from Country 2 and put the global field and a portal to Airframes there.

BTW, there's no need to filter the portal. A portal already shows only related records, and that's all you need here.

Thanks comment, That worked a treat.

Cheers

Dave