I'm probably missing something really stupid somewhere but I need to duplicate a rather complex layout using the fields from another table. Trying to explain this as simply as possible, I have a database which contains 10 tables for items. Table_0 is the master items table. Table_1, Table_2 etc are the the items for each location. All of the tables have the same fields named identically which are all related back to Table_0 using UPC as the primary key. I've now got a layout done for Table_1 (location1) it contains 32 fields with various conditional formatting and calcs to hide fields when empty. I'd like to create that same layout for all the other tables without having to start from scratch or without having to duplicate then click each field to point it to it's corresponding field from the appropriate table. There surely has to be an easy way to do this with just a couple clicks.