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

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

Gosh, it works!!!

This thing gets really addictive.....

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

Yeti