Multi-Users and Transfer Records One Portals to Another

[Spidey]

Dear All,

I have a question regarding of transferring selected records from check box from one portal to another.

If the left portal is the main database and right portal is the quotation portal. How can I make the selected items in the check box(a field in a table) and transfer them to the right portal? And at the same time, if other users are using the same main database and select their items, the field which contains the selected items won't be confused with 2 users' quote..

Thanks in advance.

Kent

P.S. Can the following link help me to solve this problem? Thanks.

http://sixfriedrice.com/wp/using-global-variables-for-list-selections/

[comment]

"main database" doesn't say much. Perhaps you are looking for something like this?

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

[Spidey]

Thanks!

Kent

[Spidey]

Thank you for your example....I am just wondering why the cartesian is used in the example..Is there a way to avoid it? I read other article that cartesian should be avoid because it produces large number of rows. Thanks

[comment]

It's because we want the left-hand portal to show ALL products. The number of rows is equal to the number of records in the Products table - and that's exactly what we need.