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

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

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

There is a post about the same thing here.

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

There is a post about the same thing here.

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

There is a post about the same thing here.

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

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?

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?

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?

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.

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.

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.

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?

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?

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?

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.

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.

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

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!.

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!.

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!.