Adding records from one table to portal

[Spidey]

Hi

Thank you for all your previous response to my questions. You guys are great help to me. Thanks!

I have another question. Is it possible to toggle one more more items from one table or in the records from the portal to another portal(product list) in my quotation template? Thanks.

Kent

[David McQueen]

Yes.

Not sure exactly what you are doing. In general terms, when clicking on the item you wish to select, either

1. capture the prime key in a global and then create a new record in the other table, populate the child key with the prime value and then lookup all of the other relevant data

or

2. Have a one record table used for transferring data and a pile of globals in it for temporary data storage. Have this table related to both affected tables in an all to all relationship (cross product or constant key to constant key relation)

When clicking in the selection table have all data set into global fields in the one record data transfer table. Then switch layouts to the target table, create a new record in the target table and then use set field script steps to set all of the data.

[Spidey]

Many thanks you for your reply. I have just wondering if my file is located inside the filemaker server, is there a way that i could have a temporary table assign for each user so they can transfer the records from one portal to another?... Thanks.