i am having trouble getting my head wrapped around this issue. This is what I am trying to do:

I have a user table, a project table, a tasks table, a activity table and a log table. Users have a set of projects they are assigned to (i am using a linking table to assign users and projects). Each project has a set of tasks (another linking table).

I want in my activity table to select the user, the date and then in a portal allow them to keep a log where they pick one of their assigned projects and then one of that projects assigned tasks, then enter time and comments.

I have a related value list that works (showing only that users projects) on the activity table if it is not in the portal, but once I try to use the projects field in the portal I get no list.

What am I doing wrong? I am new to this v7 and am probably trying to do too much too soon. Any guideance would be helpful.

Thanks

I'm not quite understanding what is wrong. But I have a feeling that the problem is that you are trying to reference one of the main tables inside a portal belonging to a join table, but that the name is not in the join table (they seldom are), nor is the source table available from the join table occurrence. This happens pretty often in 7.

To solve it, create another table occurrence of the source table, "hanging off the end" of the join table; just to be able to read from it. Be sure to name it accordingly, so you don't get it mixed up with other more useful instances of that source table.

I've come up with own naming scheme for this. I add the adjacent table occurrence as a suffix to the TO name, abbreviated, in uncapitalized letters (example, a hanging TO from Payments would have a suffix of "_pmts"). That way I know it's one of these, and I know what it's hanging off of.

Thank you. I was able to solve the first problem. The project list is now showing based on the user assignment.

However, when I do IWP this list is still totally blank. In the software it works fine. Is this a limit to the IWP and portals?