Heathbo Posted December 4, 2004 Posted December 4, 2004 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
Søren Dyhr Posted December 4, 2004 Posted December 4, 2004 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
bruceR Posted December 4, 2004 Posted December 4, 2004 What are you actually trying to do? What is the user looking at?
Heathbo Posted December 5, 2004 Author Posted December 5, 2004 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.
Heathbo Posted December 6, 2004 Author Posted December 6, 2004 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?
bruceR Posted December 6, 2004 Posted December 6, 2004 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.
Heathbo Posted December 7, 2004 Author Posted December 7, 2004 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.
Heathbo Posted December 21, 2004 Author Posted December 21, 2004 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?
Heathbo Posted December 30, 2004 Author Posted December 30, 2004 Forget it. I finally figured it out.
Recommended Posts
This topic is 7268 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now