portal field via indirect relationship?

Classic Servoy
1

I have 3 tables: A, B and C where a record in C is a child of a record in each of A and B. I have a form based on table A and wish to include a portal with the related child records in C. So far, so good :-)

But… I want the portal to include a column from C’s parent record in B.

I know I can do this by defining a calculation in C which returns the value from the related record in B (even via multiple indirections!). but for a simple indirection defining a calculation seems like the long way around. Is there something I’ve missed here?

Thanks,
Neale.

2

Why don’t you put the id of the row in table B (parent of C) into the row in table A..

That way you can create a relationship between a and b…

3

Because there is no intrinsic relationship between records in A and B, apart from the existence of records in C ;-)

Really. Table A could be a meeting; table B people; there would be a record in table C for each person attending a particular meeting.

In a form based on A (meetings) it’d be good to have not only a portal listing attendees (records in table C) but also to have in that portal details about the attendees (e.g. name/etc) which come from table B.

Regards,
Neale.

4

place a tab (on the form for table A) based on the relationship A_to_C.

On that tab you place your portal for table C. This portal shows all your A_to_C relations.

Now place a second portal based on the relationship C_to_B…

The tab can be hidden so you don’t see that…

5

Can I make this some what clear of what I think?

Tables: A. MEETINGS B. PEOPLE 3. ATTENDEES

  1. Create a Relationship from ATTENDEES to PEOPLE (using key People_ID)

  2. Create a Form (list) in ATTENDEES which has
    People_ID , People_Name (using relationship 1) etc..

  3. Now create tab panel in MEETINGS form which shows the List (created at point 2)

Hope this will work without the need of any calcs as in Filemaker.

I think Tab panels are more flexible than portals

Thanks
Ahmad
Hong Kong