ok, this is not really a question (more like a wish or a rant)

Shouldn't there be a "force to equal nothing" operator in the edit relationships window ?

For instance there is a table that has three serialID fields (A,B,C). Field 'A' is always full, but fields 'B' and 'C' have a number in a mutually exclusive way (Either one is full or the other).

Something like this:

A, B, C

2, 5,

2, 6,

2, 7,

2, , 9

When I have a relationship to field 'A', I want to make sure I get only the records that have a blank field 'C'... and I would like to use an equal operator, otherwise we can no longer jump to related records from portals and stuff (inequalities tend to break such functionality).

Right now we are forced to add zeros instead of leaving the fields blank. Those zeros take space for nothing and bugs me in the principle of the matter.

(a relationship such as blank=blank doesn't currently work)

If one is empty all previously entered values needs to get in there pilcrowdelimited....

http://www.fmforums.com/forum/attachment.php?attid/3285/

--sd