A little hard to follow, even with the screenshot.
- What TO is your layout based on?
- Are you showing the value list in a portal? If so, what TO is the portal based on?
- What TO are the values in your value list coming from?
- What TO do you have in your value list for "show only related values starting from"?
Now, what results are you seeing? All values? No values? Wrong values? There are many possible meanings for "it didn't work".
Just trying to clarify. I appreciate how hard it is to describe something sometimes, when you're already in up to your neck.
On all attempts I get "No values defined".
- The layout with the value list drop-down is attached to the Audit TO.
- I have not tried to use a portal, only a drop down on the audit layout with an attached value list.
- The list needs to be populated with the values from Disciplines table>DisciplineName. I have tried variations of TO like this but I cannot wrap my head around where the relationships are, so I am just guessing.
- A new TO of the Audit with lines drawn usernameFK in the JOIN (I have the text username populating in the usernameFK field on the join TO thinking it needed to see the actual text name)
- A new TO of Audit with lines drawn to usernameFK and discipline in the JOIN
- A new TO of Audit and JOIN with combinations of lines to either one.
- The list goes on..
- I have tried to "show only" from both the audit TO and also a new audit TOs, and from the JOIN and a new JOIN TOs.
It seems harder to explain what I have tried then just what I am trying to do. I will try to simply.
As i have it right now:
- Audit Table: Will store the entries made by users during the audit.
- User table: Will store the user information
- Discipline Table: Stores the list of disciplines
- User_Discipline JOIN: creates relationship between USERID and DISCIPLINEID
So I need the a drop down on the Audit layout (Audit TO) to see the usersname, which is set by "getaccountname", and then use that name to look at the relationship between user and discipline, only show those disciplines that are related.
I was able to do this between the parks and shows table (bottom left of the picture). What is throwing me is the username to userID/DisciplineID relationship.
I really hope this helps...
It appears that perhaps you have Audit::UserName linked to Users::UserID? If so, is that just field naming or is that a mismatch (or is the screenshot just poorly showing the relationship)?
Other than that, I don't see any other obvious candidates for the problem. If that's not it, here are some things I'd try to troubleshoot, from the Audit layout. (I'd use the data viewer for this, but if you don't have FMPA, just drop these fields on the layout temporarily.)
- Check that Audit::UserName really does have a value
- Check if you can "see" Users::UserName - if so, get a count and make sure it's 1
- Check if you can "see" Join_USER_DISCIPLINE::disciplineFK - if so, get a count and make sure it's the right number of disciplines
- Check if you can "see" "DISCIPLINES::DisciplineID - if so, get a count
- Are all the fields on the "right" side of the relationships (as currently oriented) indexed?
- Do all the field types match (number to number, text to text, etc.)?
This is, admittedly, tedious. Unless I happened to spot the problem in my opening paragraph, though, this is a good procedure to find out which relationship is breaking, and zero in on the problem.
If you do have FMPA, and you're using data viewer, also check out the RelationInfo function as a troubleshooting tool. I like it because I can compare values in actual records without going in and out of the RG, and I'm more likely to spot where I've grabbed the wrong field, or put the wrong operator.
If this doesn't get you there... this looks like a fairly small file. Is there any chance you could post the actual file, or a clone thereof? Or maybe send it to me backchannel?