Jump to content

FX and broken relationships


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

Recommended Posts

I just caught a funny little glitch after an hour of pulling my hair out.

In my FM7 database I have a relationship with a global on the left and a number on the right. The global is always 1 and the number is either 0 or 1. Since globals can't be indexed the relationship appears as broken on the TOG, but as we all know, this doesn't matter for glabals -- they can be used as the LHS of a relationship and it still works.

Except that it doesn't work as far as FX is concerned. I have a portal based on this relationship. Looks fine on my FM layout, but FX always returns an empty result for this field in my browser window, as if there were no related records.

So I switched the global to an auto-entering number field that enters 1 at the record's creation. Now it can be indexed, and it works in FM and FX.

Has anyone else come across this?

Hope this helps.

Dan

Link to comment
Share on other sites

This topic is 7094 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.