Goto related field

[JW]

I have 1 db with all the company names and a portal with the contactpersons from the company. The name, telnr. faxnr, email etc. are stored into a second db, TelFax.

Relationship = companyName

So in db 1 I can see all the persons related to a company.

Into the portal, at each row, a button to go to db Telfax, to see the details from that person.(goto related record)

But somewhere I do something wrong, I allways ended up into the first record.

Can't figured out how to set up the relationship to work.

Thanks to pointing me into the right direction.

[JPaul]

quote:

---

Originally posted by J Wenmeekers:

I have 1 db with all the company names and a portal with the contactpersons from the company. The name, telnr. faxnr, email etc. are stored into a second db, TelFax.

Relationship = companyName

So in db 1 I can see all the persons related to a company.

Into the portal, at each row, a button to go to db Telfax, to see the details from that person.(goto related record)

But somewhere I do something wrong, I allways ended up into the first record.

Can't figured out how to set up the relationship to work.

Thanks to pointing me into the right direction.

---

I also use this trick:

• Create a global field and in hich you store, at the click time, the company name & the current portrow

• Create in the related file a text field containing the primary key (company name) & the portrow

• In the master db create a relation based on this field

• At the click time fill the global and goto related rec. via this new relation.

Hope this help.

Regards.