Jump to content

nothing operator ?


Thomas An

This topic is 6123 days old. Please don't post here. Open a new topic instead.

Recommended Posts

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)

Link to comment
Share on other sites

This topic is 6123 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.