displaying info in portal

[salge2]

I have two database files. "Contacts" and "Projects". The "Project" database is using two portals to display related entries from two relationships from "contacts" called "primary" & "secondary". For each "Project" Record there are several primary contacts and each primary has several "secondary" contacts related to it. The number of "secondary" contacts for each "primary" is not known but i would like each to be displayed associated with the proper "primary" contact.

Theoretically placing a secondary portal in each line of the primary portal. Any help would be appreciated.

[LiveOak]

Sorry, you can't create portals within portal rows. Probably the best you can do is display all the primary and secondary contacts for a given project and set your relationship to sort them in an order than puts each secondary contact below its primary contact. To do this you will need to create a field in "contacts" (call it "order") and put a number in that field. Primary contacts could be 1,2,3. the associated secondary contacts would be 1.1, 1.2, 1.3, etc. This number would be entered as part of a "new record" script in "contacts".

-bd

[salge2]

is it possible to create a calculation field to assemble all of the project numbers linked to each "primary" and "secondary" contact and then use a portal in "projects" to display the information when that specific project number appears? In a sense having the project record (with a specific project number) search "contacts" for any occurrence of that number with added variables to distinguish contacts for sorting? In addition can you use a repeating field with the initial calculation?