Jump to content

Go to and find in unrelated table with portal


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

Recommended Posts

I am very new to scripting and would appreciate input to help me do the following:

What I want to do is create a button with a script that copies a value from one field in the current record in Table 1 and performs a find in Table 2 on a field in a portal to a separate table occurrence of Table 1 (and then returns the found set of records for which the field value in the portal matches the value from the original record in Table 1).

Link to comment
Share on other sites

Start by adding a global field of the type you want to usin the find. While in table 1 set the value of the global to the field. Go to table 2, enter find mode, set the value of the field in the portal to the global, perform the find. This will give the records in table that have the value in the portal. Is this what you want?

Link to comment
Share on other sites

This topic is 6980 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.