Some background first. I have a database where I have about twelve showrooms with multiple fields per line. I want to select six of the twelve showrooms so my options, so I think, are to either omit the six I don't want, or to find the six I do. I am able to successfully find one of the criteria but cannot seem to include multiple showrooms in the find field.

What I am doing now is for the Perform find I am Finding records and for my Shwrm field I put AMNY for the first field, and for repetitions put 2 and for the second field I put JRFL (and so on), but it does not return multiple. The same happens when I try to omit several. How do I do this? See pictures below.

Enter Find Mode []

Set Field [CurrentOrderStatus::Shwrm; "AMNY"]

New Record / Request []

Set Field [CurrentOrderStatus::Shwrm; "Whatever"]

Perform Find []

Edited November 8, 200619 yr by Guest

Thanks, one question though.

When I am trying to add the "AMNY" field, I go into specify calculated result (I hope) and try to put in AMNY and it states that the table cannot be found. Am I missing something? See attached photo.

Otherwise I think I got it.

You forgot the quotes which indicate a literal string, otherwise it would be referencing a field named AMNY.

GREAT!!!

Thanks, I had to figure out a couple of things but all good now!