Globals in Relationships

[michaelnyc]

Recently I had a problem with a Global field in a relationship. The rel. wouldn't return the values I wanted, but with enough messing around in the definitions the same relationship, without any changes, would suddenly work.

In an effort to solve this issue, I changed the global field into an auto-enter, without modification, and the relationship is working perfectly.

QUESTION:

Is it advisable to not use globals in relationships?

Thanks folks.

Michael

[Søren Dyhr]

Is it advisable to not use globals in relationships?

It's obvious that they only would work as primary keys, but otherwise would I say the omnipresent "It depends" ... but an awfull lot of freshing issues comes to mind when you mention it.

If we elevate our view a little further, could the use of globals be a sign of a remedy for lack of proper normalization of the structure where the cartesian relation type perhaps would be better to utilize.

I've kept this reply deliberately vague, since you question exhibit a similar notion. It's kind of same answer you get if you shout into a forrest.

Tell us where the globals failed in your case, and we could via a joined efford give it a much better stab. You get nowhere with "...issues can occure" unless you wish to keep you relationship with this tool based on prejudice.

--sd