Jump to content

scriptology problem


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

Recommended Posts

Two ways to go. First, in the Projects file you can create a portal based upon your Project No. relationship. This portal will show all the invoices belonging to that project. Another option is to create a script in the Projects file with the following steps.

Go to Related Record (Invoice relationship, show only related records)

Perform Script (external, "layout selection script in Invoices")

The external script in Invoices needs to take you to the desired layout. The found set will be the invoice records related to the project record you were on when the script was run.

-bd

Link to comment
Share on other sites

I have two files, Projects and Invoices.

What I'm trying to do is create a script that will show the invoice that belongs with a certain project (or the other way around).

I related the two files via the one thing they have in common: a unique projectsno.

I used the Perform Scriptstep to trigger a script in the Invoice file:

Goto layout ["Main"]

Find all records

Omit record

Find omitted

Perform script [Extern,"Invoice"]

I used the omit script step so that the current record gets filtered out of the lot.

The script in the Invoice File goes as follows:

Goto Layout ["Main"]

Goto related record[show only related records,"projectsno."]

Omit record

Find Omitted

But this doesn't work....I only get the first record on screen, or weird matches. There's something wrong in my line of thinking and I don't know what it is.

Can anybody help me out?

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

Yeti

Link to comment
Share on other sites

This topic is 7861 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
 Share

×
×
  • Create New...

Important Information

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