1 Reply Latest reply on Mar 28, 2013 9:52 AM by philmodjunk

    Copying style/layout to separate table


      Copying style/layout to separate table


           I have set up a table including the fields and locations of fields and did a lot of customizing with the whole layout. I have about 6 tables and I would like all of them to look the same without having to spend time on each one to try to copy the layouts. 

           My question is, is there anyway to copy the layout without linking the tables to each other? I have tried duplicating the layout and then deleting the old layout but as soon as i do that all of the fields display unrelated table. Is there another way to do this?

        • 1. Re: Copying style/layout to separate table

               If you have 6 tables that would use exactly the same layout, then there is a very real possibility that you should only have one table but with a "category" field that lets you work with 6 different groups of records on the same layout--which would eliminate the need for what you are describing.

               You can enter layout mode and select Duplicate Layout from the layout menu. Then enter Layout Setup... to select a different table occurrence in the Show Records From drop down found there. But if you do that, you then have to double click each field on your layout and reselect the field in Specify Fields to come from the newly specified table occurrence. If you have any portals on the layout, they need the same update process including an update of "Show Related Records From" in Portal setup.

               It's also possible to copy and paste all the objects on a layout and with a bit of "sleight of hand", you can avoid having to respecify fields: Importing Layouts