Macros and Programming

Normally to make a selection from two different fields you first select Field1 and then Field2 (here the fieldnames are Length1 and Length2):

x=InputBox(prompt,"Enter length (cm)")
ActiveWindow.Select "Length1",":"+x
ActiveWindow.Select "Length2",x+":"

After the selection you are in Level 2.
To undo this selection you have to go back 2 levels.

But is it possible to do the selection in one command line so that the Level is 1 (and not 2)?
Something like:
ActiveWindow.Select "Length1",":"+x AND "Length2",x+":"

I know that this does'nt work.

Has someone a better idea?

thanks,
Herman

Impossible. Search in one field or in all fields.

Can you explain why you want to this on Level 1?

However: I see you want to do this in a macro (Inputbox).
If you want the result on Level 1 than you can 'keep' the records which you search first, then do a second search and add that records to the first 'keep' records. Then ClearAllLevels and select the records of the 'keep' = Level 1.
Regards
Bert