1 Reply Latest reply on Dec 8, 2009 10:25 AM by philmodjunk

    Help with database setup with products with many suppliers

    tommytowbar

      Title

      Help with database setup with products with many suppliers

      Post

      Hi

         need some help on best way to do this I have a few supplier and they sale the same stock at different price and not sure how the best way to do this as some products need information from 1-6 supplier so I can see my option when looking up product information

       

       

      E.g.

              product a 1 database

             

              supplier a price       2 database

              supplier b price

       so I can add supplier to the list if you see what I am getting at

       

      Andy

      filmmaker pro 10

      vista

       

        • 1. Re: Help with database setup with products with many suppliers
          philmodjunk
            

          I believe that you are storing this information in a second table (It can be in the same file or a different file if you're using a recent release of filemaker):

           

             supplier a price 

             supplier b price

           

          If so, you have two options:

           

          Option 1: Best for data entry:

          Use a portal on a layout that is based on "Database 1" that displays related records in "Database 2". You can look up "portal" in Filemaker Help to learn more.

           

          Option 2: Best for printing/Preview/PDF reports

          Create a summary report based on Database 2 and place the fields in Database 1 that you need to see in a Sub-Summary part "sorted by" product.

           

          You may find it best to use both methods on separate layouts.