Hello everyone, please help.

I have a one to many structure set up, which looks like this:

Customer has multiple communities, communities have multiple job types, job types have multiple jobs, jobs have multiple products.

On the first layout the customer selects the communities from a checkbox value list (List view, long list). The IDs get stored in a text field (Selected IDs), which relates to the Community ID, then they GTRR and on the next layout they see the communities they have selected. And so on until they get to the products.

That all works fine for one customer, but as the Selected IDs field is not a global (can't use one because it will have one value for all in the list view). Problem comes when another customer goes to the same layout they start overwriting and messing each others selections up.

So how do I make the relationship so I can still store multiple selections for each line, and still have user independence like a global field?

Thanks in advance, appreciate any help.

Actually, you do need to use global fields to mark records in a multi-user environment.

http://fmforums.com/forum/showpost.php?post/293833/

How come you're not just finding in the Products table?

Make selected ID a global.

1. In a relationship the table you are looking from can have a global as ong as the table you are looking to has indexed key fields.

2. The nature of global fields is that a single user will see the same value over all records. In a multi user scenario, each user sees only their own values. So this field as a global will not havethe same values in a list view for all users, just the current user's selections.

HYH

Dave

Thanks for the help.

I was working on the file you sent me and I think I figured it out.

I am attaching it here for anyone that might have the same problem.

Thanks Again.

Filtered_Value_Lists.fp7.zip