Jump to content

Finding related records


This topic is 8507 days old. Please don't post here. Open a new topic instead.

Recommended Posts

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

Link to comment
Share on other sites

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.

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

Link to comment
Share on other sites

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")

Link to comment
Share on other sites

This topic is 8507 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.