finding field A and/or field B or leave blank for all

[homosapien.tv]

Hello

I've got another script that I'm having a little trouble with. Thanks to Liveoak I got through the other one a while ago.

Basically I'm within the one file that I want to do the find on.

So:-

1/ I've got field A (date) and field B (person's name). Put either, both or nothing in then push a button.

2/ Based on that it returns all matching fields otherwise if both left blank it returns all records.

Thank you in advance

Drew

[rdhaden]

All find criteria in one find requests acts like AND (i.e. finds records for which that name and date both appear in the record).

One find criteria in one find request and the other find criteria in a second find request acts like OR (i.e. finds records for which either that name or that date appear).

If IsEmpty(gFindCriteria1) and IsEmpty(gFindCriteria2)

Show All Records

Go To Layout (FindResults)

Else

Enter Find Mode

Set Field (Date) = gFindCriteria1

New Request

Set Field (Name) = gFindCriteria2

Perform Find

Go To Layout (FindResults)