Duplicate portal records in FMP7

[Jalz]

Hi Guys,

Any tips or hints on the most efficient way to duplicate Master and Child records in FMP7. In FMP6, I used to use John Mark Osbornes duplicate portal example (www.databasepros.com), but this does not work with the newer version of FileMaker unfortunately.

Cheers

[Jalz]

Hi Guys,

Any tips or hints on the most efficient way to duplicate Master and Child records in FMP7. In FMP6, I used to use John Mark Osbornes duplicate portal example (www.databasepros.com), but this does not work with the newer version of FileMaker unfortunately.

Cheers

[Jalz]

Hi Guys,

Any tips or hints on the most efficient way to duplicate Master and Child records in FMP7. In FMP6, I used to use John Mark Osbornes duplicate portal example (www.databasepros.com), but this does not work with the newer version of FileMaker unfortunately.

Cheers

[mr_vodka]

There is a post about the same thing here.

http://www.fmforums.com/threads/showflat...true#Post151036

[mr_vodka]

There is a post about the same thing here.

http://www.fmforums.com/threads/showflat...true#Post151036

[mr_vodka]

There is a post about the same thing here.

http://www.fmforums.com/threads/showflat...true#Post151036

[Jalz]

Hi MrVodka,

Yes, I contributed to that post, as they were requesting a FMP6 example.

However, I'm using FMP7, and the example you provide, doesn't duplicate the portal records, which is what I'm making a request for. I need both Master and Portal records to be duplicated.

Thanks for looking though, any other ideas?

[Jalz]

Hi MrVodka,

Yes, I contributed to that post, as they were requesting a FMP6 example.

However, I'm using FMP7, and the example you provide, doesn't duplicate the portal records, which is what I'm making a request for. I need both Master and Portal records to be duplicated.

Thanks for looking though, any other ideas?

[Jalz]

Hi MrVodka,

Yes, I contributed to that post, as they were requesting a FMP6 example.

However, I'm using FMP7, and the example you provide, doesn't duplicate the portal records, which is what I'm making a request for. I need both Master and Portal records to be duplicated.

Thanks for looking though, any other ideas?

[ralph.nusser]

LESAUX has released DECEMBER 12, 2004 a [color:"blue"] Guide To FileMaker 7 Relational Design ( FMP 7 ) a resource of FileMaker 7 relations with over 150 pages of content and 30 example files. Cost: $18.95.

One of the example files shows how to duplicate an invoice head table and the line item table: Duplicating A Master & Related Records - [color:"blue"] duprel1.fp7 Page 128

It's worth the $18.95, you will learn many other things as well. If you bought it post your opinion here.

[ralph.nusser]

LESAUX has released DECEMBER 12, 2004 a [color:"blue"] Guide To FileMaker 7 Relational Design ( FMP 7 ) a resource of FileMaker 7 relations with over 150 pages of content and 30 example files. Cost: $18.95.

One of the example files shows how to duplicate an invoice head table and the line item table: Duplicating A Master & Related Records - [color:"blue"] duprel1.fp7 Page 128

It's worth the $18.95, you will learn many other things as well. If you bought it post your opinion here.

[ralph.nusser]

LESAUX has released DECEMBER 12, 2004 a [color:"blue"] Guide To FileMaker 7 Relational Design ( FMP 7 ) a resource of FileMaker 7 relations with over 150 pages of content and 30 example files. Cost: $18.95.

One of the example files shows how to duplicate an invoice head table and the line item table: Duplicating A Master & Related Records - [color:"blue"] duprel1.fp7 Page 128

It's worth the $18.95, you will learn many other things as well. If you bought it post your opinion here.

[Jalz]

Hi Ralph,

Thanks for your suggestion. It's certainly alot cheaper than subscribing to FileMakerAdvisor, which is what Im planning to do. As Im at work, I haven't gone on the Lesaux site, but do you happen to know the table of contents of the package Lesaux are selling at &18.95?

[Jalz]

Hi Ralph,

Thanks for your suggestion. It's certainly alot cheaper than subscribing to FileMakerAdvisor, which is what Im planning to do. As Im at work, I haven't gone on the Lesaux site, but do you happen to know the table of contents of the package Lesaux are selling at &18.95?

[Jalz]

Hi Ralph,

Thanks for your suggestion. It's certainly alot cheaper than subscribing to FileMakerAdvisor, which is what Im planning to do. As Im at work, I haven't gone on the Lesaux site, but do you happen to know the table of contents of the package Lesaux are selling at &18.95?

[mr_vodka]

Hi Jalz,

You are trying to create a master record with subsequent portal records correct?

Making a few script changes for the upgrade to 7 should work. Its the same basic concept of creating a duplicate record of the master duplicating the related records and changing the key to the new key. With 7 you have to enter into the layout first since most of its it in one file with different tables.

[mr_vodka]

Hi Jalz,

You are trying to create a master record with subsequent portal records correct?

Making a few script changes for the upgrade to 7 should work. Its the same basic concept of creating a duplicate record of the master duplicating the related records and changing the key to the new key. With 7 you have to enter into the layout first since most of its it in one file with different tables.

[mr_vodka]

Hi Jalz,

You are trying to create a master record with subsequent portal records correct?

Making a few script changes for the upgrade to 7 should work. Its the same basic concept of creating a duplicate record of the master duplicating the related records and changing the key to the new key. With 7 you have to enter into the layout first since most of its it in one file with different tables.

DUP_combined.zip

[Jalz]

Thankyou Mr Vodka!

You are a *star*...... I now know what I was doing wrong! I had virtually the same code, but I wasn't going to the child records layout when using GTRR command. For the second script, which dups the child records, my exit record if script had the following code "Get ( TotalRecordCount ) = 0", which was totally wrong.

I think it will take me a while to cut my teeth into 7, hopefully its going to be worth it!.

[Jalz]

Thankyou Mr Vodka!

You are a *star*...... I now know what I was doing wrong! I had virtually the same code, but I wasn't going to the child records layout when using GTRR command. For the second script, which dups the child records, my exit record if script had the following code "Get ( TotalRecordCount ) = 0", which was totally wrong.

I think it will take me a while to cut my teeth into 7, hopefully its going to be worth it!.

[Jalz]

Thankyou Mr Vodka!

You are a *star*...... I now know what I was doing wrong! I had virtually the same code, but I wasn't going to the child records layout when using GTRR command. For the second script, which dups the child records, my exit record if script had the following code "Get ( TotalRecordCount ) = 0", which was totally wrong.

I think it will take me a while to cut my teeth into 7, hopefully its going to be worth it!.