Hi all, can you help with the following:

I have a pretty basic list of contact names (experts) including an extra field listing their expertise (keywords) on a form layout. Is there a way of doing a search where the list of names resulting from that search appears in a permanently positioned portal on that same form layout?

Secondly, let's say I see a list of 8 names that result from that search, I then want to peruse that list in the portal and have the ability to then click on one of the 8 names so I can see their entire record on that same form layout page.

I realise I can create a script where the resulting list can be viewed as a list or table in a different layout but I want the ability to not change from the original form layout if that is possible...

Any thoughts?

Either tag each record in the found set with an extra key acting as temporary foreign key for the portal relation or gather the recordID's of each of the found in a pilcrow delimited list and make it work as primary key in a global field.

The latests solution is definately the one in a multi user environment since each user has his/her own values stored in globals when networking. Now the collection of the ID's can follow many algorithms of which can be studied in this template:

http://www.databasepros.com/FMPro?-DB=resources.fp5&-lay=cgi&-format=list.html&-FIND=+&resource_id=DBPros000663

Depending really of the exact use! But basicly can the technique be studied by watching this video:

http://www.filemakermagazine.com/secured/transfer/550/PortalResults_full.mov?key=a341485e0df5773fe759d3003c607b33

--sd

Edited August 8, 200916 yr by Guest

Thanks so much SD

That video link you provided was a huge help and it looks like I've got it working.

Thanks again.