Finding related records

[Peterc]

I have a "company" database and a "contacts" database with a portal in the "company" database showing the contacts related to their company. I have a script that prints out labels of all employees from a found set in the "company" database. But what I would like, is to put the employees into groups, to mark them in the portal, and then only print labels for all company's with contacts that belongs to that group.

Can anyone help?

Thanks

Peter

[Claus Pedersen]

You will need to do the following:

(I take it that you mark the contacts in the portal with a field (MarkedYesNo) that indicates "YES", when they should be printed)

1. Create a calculation field in the Company base giving the value "CompanyID/YES", also create a global textfield named gRel.marked.

2. Create a calculation field in the Contacts base giving the value "CompanyID/MarkedYesNo"

3. Create a relationship from the Company base to the Contacts base, based on gRel.marked to the new calculation field in contacts.

4. Whenever you want to print the labels of the marked contacts in the found set of companies, go to a layout that has only the "CompanyID/YES" field. Copy all records.

5. Paste the result in a new layout into the field gRel.marked.

6. Use Goto Related records of the relationship , and print the labels from the Contacts base.

In this way you show related fields to the Companybase, that has been marked.

------------------

[Peterc]

Tak Claus

But how do you set up a calculation field giving the value "CompanyID/YES"? and the the field in the Contacts portal marking them "Yes" or "No" would that be a simple popup menu...

Thanks ("Dansker i New Zealand")