1 Reply Latest reply on Jul 5, 2013 12:04 PM by Ooglethorpe

    New table with same layout

    scott_cassidy

      Title

      New table with same layout

      Post

           Hi there,

           I'm building a database of products with their corresponding codes, descriptions, prices etc.  I've chosen the invoice starter solution layout as it works well with what I'm trying to accomplish.

           Though I don't want ALL of our products under one table.  We buy from different manufacturers and I'd like to group each set of products in several different manufacturer tables.

           I've tried creating a new table, and linking it up in the Relationships window, though upon its creation its in the default layout.  I'm unaware as to how to change that layout to the one like the starter solution.

           I also tried duplicating the first table in the starter solution layout I want, though if I try editing the new duplicated layout, it also edits the original.  Therefore this isn't an adequate solution.

           I'd appreciate any help, thanks so much!

           Scott

        • 1. Re: New table with same layout
          Ooglethorpe

               My first thought isn't to answer your exact question but question why you would divide your products up into different tables based on manufacturer instead of just including Manufacturer as a field in your Product table? Are you also tracking other information about your Manufacturer in your Manufacturer table? If you keep all your Products in one table with Manufacturer just being another field in that table, you'd have the ability in any portal related to your Products table to sort products by type, manufacturer, etc. which you won't be able to do if the products are scattered across many tables.

               As far as what you are asking though, have you used the Layout Manager to associate the layout you want with the Table you want? Sounds to me that your duplicated layout is still based on the original table and all the fields in it are still referencing that same table.

               If you were to go into Layout Mode, then click Layout>Layout Setup, it calls up a window that allows you to associate the current layout with a particular table. Also accessible under Layout (when you're in Layout Mode) is the "Change Theme" window. Either of these might work for what you are actually trying to do.