Relationship Doesn't Work

[sherifmayika]

hi,

Here is attached file where I have trouble in reationship. I am geting a message that one or more between Relationship these tables are invalid.

Any kinf of help would be apreciated.

filteringValuelist.zip

Edited July 27, 2006 by Guest

[Fenton]

I see something odd with the SL field in MembersParticipated. Its Storage indexing has been set the "None", and "Automatically create indexes as needed" is unchecked. This makes unusable as the target of a relationship. If you look at your graph you'll see the the line is there, but that side looks like it would for an unstored field: -|

You could set indexing to either "Minimal" (default) and check "Automatically create indexes as needed" (default), or set it to "All". Then close Define Fields. Open it again and you'll see that SL is now indexed, and its line is attached in the Relationship Graph: -<| (can't really draw it here).