I have 3 tables:

Members

globals (Holds the 'yes/no' fields shown below)

MembershipType (holds PKID and MbrType (Type of Membership)

The Members::Type field is a drop-down based on the MemberShipType table.

I have 2 layouts:

Members::Members

Setup:: ?? (nothing seems to work)

As shown above, I need to let the user define the MembershipType (MbrType field) in the left column. Then I run a script that looks at the selected MbrType on the Setup Layout and calculates the 'Dues' according to the Yes/No answers to the right of a particular MbrType. This part works.

Problem: I can't get the portal to show records. grrrr

I have tried: relating MembershipType to Members::Type with X (cartesian join)

I have tried: relating MembershipType::MbrType=Members::Type

I have tried: basing the Setup layout on Members. Nope. And on MembershipType ... Nope.

All I want is for the user to be able to type a Membership Type into the portal on the left and then that listing of fields in the portal to show up on the Members::Type drop-down.

Shouldn't that be doable (sic) ?

I have been working on this for 2 days and am seriously stuck. It seems this should be really simple. What am I missing? ?

Thanks

Ok. I think I 'got' this one to work. Here is how I 'CURED' the problem of not being able to add portal records.

a) I base the Setup portal or members.

I established a 'X' Cortesian join between MemberType:MemType X Members::Type.

c) I put the portal as shown above.

d) When browsed, I can not add records to the portal. So...

e) I made a layout that just had the two records (IDPK and TYPE).

f) Scripted ADD RECORD

g) Went back to setup and there was a new record in the portal. All I have to do is put an '+' button tied to the script above the protal.

Just for my edification, "Does anyone know why I can't add records to this 'X' Join; like a regular portal

Thanks

Ok. I think I 'got' this one to work. Here is how I 'CURED' the problem of not being able to add portal records.

a) I base the Setup portal or members.

I established a 'X' Cortesian join between MemberType:MemType X Members::Type.

c) I put the portal as shown above.

d) When browsed, I can not add records to the portal. So...

e) I made a layout that just had the two records (IDPK and TYPE).

f) Scripted ADD RECORD

g) Went back to setup and there was a new record in the portal. All I have to do is put an '+' button tied to the script above the protal.

Just for my edification, "Does anyone know why I can't add records to this 'X' Join; like a regular portal

Thanks

I thought the Cartesian Product describes a relationship where any record in one table occurrence will match all the records in another table occurrence.

You either have to script a new recordset using magic key, global, id_primary --> child::id_foreign,etc

I thought the Cartesian Product describes a relationship where any record in one table occurrence will match all the records in another table occurrence.

You either have to script a new recordset using magic key, global, id_primary --> child::id_foreign,etc

OR CHECK ADD new Record via this relationship checkbox.. : )

OR CHECK ADD new Record via this relationship checkbox.. : )

When I check the cartesian join, the 'add new records...' checkbox is grayed out. It is a real problem not being able to let the portal create a new record.... Is this the way FM wants this to work?