is there anyway to perform a find within a script where the condition is the value contained by another field? for example if i want to search where field 1 = the contents of field 2?

Thanks,

Anthony

Something simple would be:

Enter Find Mode [ ] {leave all options off}

Set Field [ **calculation goes here** ]

Perform Find [ ]

** your calculation would be something like: [TableName::field1, TableName::field 2]

Hi

can i ask how you would solve this:

in browse mode a value is chosen with a popup-menu in field "searchkey" (the popup looks up all entries from field "category".

than a button is activated to run a script which should filter all records to an exact match with the 'searchkey".

My script enters the findmode, i try to place the value of "searchkey" into field "category" and then perform a find. But the value is lost when entering find-mode.

how do i solve this.

thanks

Make the menu a global and relate it to the category field. Don't enter Find Mode; simply Go to Related Record [show only related, "yourRelationship"].

Something simple would be:

** your calculation would be something like: [TableName::field1, TableName::field 2]

I can't quite get what you suggest here...

I'm following your script steps, but for this calculation, i just can't get it to work. I tried [TableName::field1=TableName::field2] but it puts a "1" in the destination field..

any ideas ??

There is no equal sign in the example; there is a comma, which should be a semicolon in 7.

Set Field [TableName::field1; TableName::field2]

where TableName::field1 is the target field and TableName::field2 is the calculation.

GTRR would still be faster than a find, though.

I thought maybe Fennas was trying to find all records where two fields have matching contents, rather than find all records which have a field value equal the value of a global field. If so, then just create a calculated field "Match" with the formula:

Field1=Field2

Then search for records where Match = 1

thanks for the suggestions guys this solves my problems.

I hate it when I completely misread a question.