Example: In table 1, I have a portal row with 5 different entries. I table 2 I have another table with the same layout and portal setup. How do I, at the push of a button transfer all the entries from the portal in table 1 to the portal in table 2?

Thanks for your help

Heathbo

You can import between tabels, but you need to split the process into two, first single out the portals records GTRR(SO) perform the import, then:

Show all records

Omit

show omittet only

Perform Script[

...which calls the subscript that import the single (parent) record to the corresponding table.

--sd

Just launch another view of the Window.

What are you actually trying to do? What is the user looking at?

In table 1 there is a portal row which is linked to another table with just regular records (text fields and pictures). Table 1 is used to bring together a list of players to be used in a game. Table 2 is used after the game is played to detail the specifics of the game. What I'm trying to do is, after I've got the list of players together in table 1, I want to be able to push a button and all the records in the portal in table 1 will be transfered to the portal in table 2.

I have all the records that are brought into the portal in table 1 organized by serial numbers. Thats how their brought into the portal. Would the easiest way be copy and pasting the serial numbers into the portal in table 2?

Doesn't make any sense yet. Why move them to table 2? If you want a layout based on the same portal, that is the same set of records, l but with different fields disiplayed in the portal, then just duplicate your existing layout and display different fields in the portal.

Because teams of players need to be put together in advanced. Not all teams will play and some will play many times. Each time they play will need to be a seperate record because of recording notes and other data associated with that peticular game.

Regardless of whether it makes sense or not, how would I grab all the records in the portal in one table and transfer them to a portal in another table? Would copying the ID # for each record in the first portal and pasting them into the ID# for each record in the second portal be the easiest?

Can you post an example?

Forget it. I finally figured it out.