I have two files. clients.fp5 and events.fp5 and I want that some clients participate in some events but other no. Every event has a ID field that do it unique. In events layout I have a portal with all clients and I want to select some one. How can I do it?? Thank you very much and excuse my English. -)

In your participant portal do not list all clients.

Add the clients via a popup menu that is built from the clients list. and then have a auto calc that pulls in that clients id from that client match.

Good luck

I heva a problem.. My list of clients is very long.. Can I select the clients from portal means check boxes or means a script?? thank you..

I use this the popup menu on a clients solution with about 5000 names and it works fine. Note when the menu shows you can start type to get to the desired name.

Your other option would be to create a script that goes to the actual client DB and lists all names. Click on the name you want and then have the script set the ID to the event.

I am staying away from the portal idea because scrolling through a large portal is a pig. Portals always snap to the top once you click out.

Your choice... good luck

Ok that is good!! How could I do the script... please... I