I've attached the file: join.fp7 log/pass: admin/admin

there are 3 tables in this file:

people

groups

group enrollments <--(the join table)

2 things aren't working..

1. the Group Enrollments portal on the People table that should show which groups they are in is not displaying anything

2. the Groups value list on the Group Enrollments table will not list any values -- it doesn't seem to be working because I asked the value list to list the ID # field and also the group_name field... which I should be able to do.. right ? so that when the user is making an enrollment.. they'll know which ID correlates to which name. The People value list seems to work fine.. because I only have the value list showing one field (Person_ID)-- the match field... but how then could my user know which person they are assigning merely by looking at the ID # ? suggestions please thanks :-)

any help you could provide would be most appreciated.

join.fp7.zip

I downloaded your file and I don't seem to have any problems. I get the value list drop down fine.

I do have a question as to why you are using a calculated field to get the name? Was it to use the

"-" cause you could easily just use the Group Name as the second field.

This is extremely strange... I do NOT get the Groups value list. I merely see a blinking cursor when I click into that field on the Group Enrollments layout.

could someone else test it please ? I'm at a loss for why it doesn't work for me but worked for you.

I tested it on 2 computers.. a g4 cube 450 and a 1.5 Ghz Powerbook.

Any chance you used the file on a PC ?

Yes.. I did use a calculated field in order to get the " - Group Name" added. I tried to just list the Group Name as well as part of the Value list, and that would also prevent the value list from listing for me.

I had the same problem. Running WinXP.

When I changed the sort order to sort by the first field instead of the second, all was well. In either case I would get rid of the calc field and use GroupName as the second field in the value list. Should give you what you want and I did not experience any problems with either sort order.

I figured out why the value list wasn't popping up..

I found out why that value list wasn't working.

Indexing needs to be turned to "all" for that field It was set (by default, I think) to "minimum"

If someone can tell me why the portal isn't working.. please do. (it should list group enrollments for a few of the people)

You need to assign groups to which your 'people' are assigned to. I'm assuming you have already done this. You are correct in that in the portal, you can place the group field from your table occurance of Group.

If the context of your layout is people, then you can create a portal to the Group Enrollment Table and place the Group ID field from the Group Enrollment TO and the Group Name from the Group TO.

Hope this helps.

Yes, it was an indexing problem. But I don't see why it shouldn't work like you set up.

On mine, I unchecked the "do not evaluated if fields are empty" checkbox, in the calculation dialog. Then it worked fine, even with "minimal" indexing. And, if I checked the checbox again, it still worked fine.

There was an earlier bug, which would cause some calculations (constants especially) not to evaluate sometimes (imports especially) unless that box was unchecked. But it was explicitly fixed in 7.0v2.

This seems to me to be either a deeper level of that same problem; or we're supposed to always manually turn on indexing for calculations using constants (i.e., only 0 or 1 field was referenced) used for value lists. So it seems like a subtle bug, fortunately easily noticed and fixed.

Oh, yeah, your portal isn't working 'cause you're using a different prefix on your ID. One's using "PE", the other "PR".