Another Portal related to a portal

[sherifmayika]

hi,

I am working on a event DB for a non-profit.

I have 4 tables

T1.Members_contact

T2 Daily events

T3 Events

T4 Members_Participated

'Daily events' and 'Events' are Related

'Events' and 'Members_Participated' are related also.

In the daily events layout I have a DateField and and portal . The Portal has two fields from eventstable, 1. sl no, 2.eventname

In the events layout I want mark mebers participated using portal from the table Memebers_participated

Everything workrd fine for me the only problem I faced is that nothing is showing in the second portal which I want to mark members participation

any help would be appreciated

sheriff

Edited July 21, 2006 by Guest

[Matthew F]

It sounds like you were able to get it working for the first set of tables so it should work with the second as well. I'd check to be sure that the match field exists in both tables and that (initially) the field storage has indexing turned off.

In the relationship graph be sure that the correct fields are being matched, and the tables are connected with an "=" sign and not an "X" or some other symbol. On the Events layout check "Layouts setup..." to be sure that you are displaying records from the correct table (Events).

Hope that helps!

:)

[sherifmayika]

It works perfectly. The problem was indexing.

Thank you very much for your help.

But it now raised another problem, when a script is triggered to open a new window to mark the members participated the previous window also changes it’s size automatically

Have any idea

Portal_In_a_Portal.zip