3 Replies Latest reply on Oct 27, 2016 3:29 PM by philmodjunk

    make a portal with non empty table records

    MilkoMigneco

      Hi community

       

      I'm working on a database for all the items we sell, one table under the database have all item specifications and its related to the main table through the SKU of the item.

       

      Specification table have several fields as you can imagine, each field is the name of each specification, (ex. dimension "a", dimension "b", thread, material, shaft, etc. All items does not share the same specifications, (vises does not use the same specifications/fields of drills for example), hence, the table have a lot of empty fields.

       

      I need to include a portal in the item layout that shows all specifications for each item. I just cant add all fields from the related table to populate the portal because not all fields apply for each item, as I said before each item family share a group of specifications/fields, I thought that if I add all fields from the related table I will have a very long portal with a lot of empty fields.

       

      Is there a way I can show only related fields for each item that actually have a value? this will let me see a portal with only populated fields and hide all empty fields.

       

      Is there a different way to achieve the same goal?

       

      Thank you

       

      Milko Migneco

      FileMaker Pro Adv 13.

        • 1. Re: make a portal with non empty table records
          philmodjunk

          You might restructure your specifications into a group of records for each item instead of one record with many unused fields.

           

          Each record might have three fields: Sku, Label Field, Data. You might add a fourth field for units.

           

          Then your portal can list this group of records to show the specifications for a given SKU.

          • 2. Re: make a portal with non empty table records
            MilkoMigneco

            Thank you for your reply.

             

            I dont get your response. Sorry if I wasnt clear about the structure of the database.

             

            What I have now is one record per item, each record have all the fields I need for each item, in this main table all fields are common for all items, (Sku, name, purchase model, manufacturer, etc). Specifications are on a related table, again, one record for each Sku. In this table I have all specifications that apply for all items, one field for each specification. records on this table are filled only with the fields that apply for each Sku, the rest are kept empty.

             

            Portal is on the items layout using data from the main table and showing related fields on the portal from the specification table.

             

            Solution need to show me a portal with only related fields that have a value for the Sku.

            • 3. Re: make a portal with non empty table records
              philmodjunk

              What I am suggesting is that you change that very structure that you have so that you have something that handles the variable specification values more flexibly by using a set of records with just a few fields instead of one record with many fields.

               

              This also seems a better use of your portal since a portal is usually used to display multiple records yet in your current design you appear to have one record with one SKU matching to one Specification record.