A better way?

[Dana G]

I have a client that needs nearly the exact same information for two different programs. The client wants to use a an existing layout (master budget agreement) as a template for this new second program.

I can duplicate the table and the layout but what I would like to know is if there is an easier or faster way to assign the new table fields to the new duplicated layout.

All fields change to related fields when I duplicate the original layout and change the "Show records from" pull down to the new table. All the field names are exactly the same...there has to be an easier way than going through field by field and changing them to the new table.

[comment]

See if this helps:

http://fmforums.com/forum/showpost.php?post/222950/

[Dana G]

A truly heartfelt thank you! You have saved me countless hours of double-click field, click TO, home key, assign new field...over and over and over.