How to create a selection portal?

[Guest_imported]

I have a business contacts database with two tables. The relationship is one to many. The first table contains one field: firm name and the second has fields of address and contact person. I want to create a portal with rows of the names of contact person on the left of the layout and the individual address on the right. When I click on the name on the portal, the address will change accordingly.

Does anyone know how to do it?

 

[ImStevenB]

OK,

In the portal on the left:
- Create a button and place it in the row with the name (you can also make the button transparent and put it over the name).
- Create a script that will go to the selected record (Go to Related Record script step) and copy the unique record ID to a global field.
- The portal on the right should show the related information (use global field to record ID for the relationship)

Here's an axample,

On the left you have three names

Tom Johnson
Bill Thomas
Joe Dufflebag

You want to see Joe's information - so you click on Joe's name. The script will take his record number, say it's 354, and copy it to a global field named gRecID.

The left portal has a relationship to itself where gRecID = Record ID (Self Join).

The left portals fields that are displayed come from the relationship.

I hope I explained this clear enough. If you want me to email you an example, just post the request and I'll send it.

HTH Im Steven B

http://www.myarcadia.net

 

[Guest_imported]

Im Steven B

Please email me an example to asiaic@hotmail.com

Thanks in advance.

 

[ImStevenB]

I emailed the file to you. You should see it soon.

HTH Im Steven B

http://www.myarcadia.net

 

[Guest_imported]

i saw this question on the thread list and tried to do what Im Steven B said.

But I can't get it right could any of you email an example. TY

jake