I've got to be an idiot

[stapes]

Any help greatly appreciated.

Two tables: data and results. Trying to create a relationship where [data]name=[results]name and [data]date=[results]empty where empty is a date field with nothing entered. I'm thinking that find related records will show me all of the records in data where there is no date entered, but no. I've got to be missing something really simple, its driving me nuts.

[Genx]

Relate them via a stored calc field

data_calc = If( IsEmpty( data ) ; 1 ; data )

results_calc = If ( IsEmpty( results ) ; 1 ; results )

Relate those two fields instead, again make sure they are stored.

[stapes]

Many thanks for your reponse, but still no go. All fields in the relationship are indexed. I've checked and rechecked the entries...works if only one of the fields is related, but not if both (this AND that)

This one has me stumped.

[stapes]

My bad...works now. Didn't have proper values in 'Date is Empty' calculation. Just out of curiosity, why doesn't FM recognize empty and empty? Why the need for a calculation?

I'm not as much of a rookie as this sounds...been working with FM for 15 years now..client of one - me. So am by no means a pro...

[Genx]

LOTS of valid reasons trust me.

Plus in database design it's not standard to try to relate empty fields and all db programs in this way are similar ( i.e. NULL will never equal NULL ).

It's like saying... "no apples" is equal to "no oranges" or "no money" is equal to "no stocks".