Simple Find proving difficult for me

[Corey-Troy]

I have 2 tables that are related via a number field[CSID].

One is on a costing layout, the other on a quote layout.

I have created a script, that IF a quote is required, then a New Record{quote} is generated, and the [CSID] from the Costing layout is copied and pasted into the Quote layout [CSID]field.

The script also copies the New Record[QTquoteID] that was generated, and pastes it into the Costing layout[CSquoteID].

All is well with that.

However, i want to create a script for the user to run, to be able to navigate from the Costing layout, to the related Quote layout.

I have tried a variety of different methods of Find etc, but cannot get the correct script to go to the correct Record in the Quote layout that is related to the Costing layout.

In logical terms it is as below:

Find Costing Layout::{CSQuoteID} in Quote layout::

.

But it is beyond my ability to do this.

How can i do this successfully?

Corey....

Edited December 8, 2009 by Guest

[Fitch]

When you say "the related Quote layout," do you mean related in the FileMaker sense, i.e. there is an actual relationship between the tables? If so, have you tried using the Go to Related Record script step?

You can also do it with a Find like so:

 /* (assuming you're on the Costing layout) */

Set Variable( $quoteID ; CSquoteID )

Go to layout( Quote )

Enter Find Mode

Set Field( QTquoteID ; $quoteID )

Perform Find

Note that you should not specify any "restore" options for the Enter Find or Perform Find. Also, you may want to add some error trapping to the script in case no records are found for some reason.

[Corey-Troy]

Thanks for the reply Fitch.

When you say "the related Quote layout," do you mean related in the FileMaker sense, i.e. there is an actual relationship between the tables?

= Yes

If so, have you tried using the Go to Related Record script step?

= Yes,

It takes me to the Layout, but not to the required Record for some reason.

I do not need error capture here, as i eliminated the possibility of no record in a previous script.

I ALMOST get the result, i have:

Set variable[$QuoteID;Value:Costing Sheets::Quote Number]

Go to Layout["Quotations"(Quotations)]

Adjust Window[Maximize]

Enter Find mode[]

Set Field[Quotations::Quote Number;$QuoteID]

Perform Find[No Dialog]

This gives me the record, but i am still in Find Mode.

If i hit the Enter Key i get the result required.

If i add a step as: Enter Browse mode[] after the Find, i go to the incorrect record for some reason.

Edited December 8, 2009 by Guest

[Corey-Troy]

Solved.

I accidentally used the Perform Find/Replace instead of the perform Find.

All is well now.