trouble with record selection

[exc]

i have 2 tables...parent and child. one to many relationship. i need to pull records from the parent table based upon event codes in the child.

example...i need to pull a parent record where in the child table there exists a record for event 1 and 2 but not 3.

what type of formula can get this done?

eric

 

[FoxG]

Hi,

Assuming your event1,2 and 3 are string fields then

not (isnull({event1}) or isnull({event2})) and
isnull({event3})

or

(event1 <> &quot;&quot and (event2 <> &quot;&quot and (event3=&quot;&quot

depending on whether your empty fields have null values or zero length string values.

Hth,
Geoff