3 Replies Latest reply on May 19, 2014 9:41 AM by philmodjunk

    Printing Shipping Label one time for multiple entries

    ejolesch_1

      Title

      Printing Shipping Label one time for multiple entries

      Post

           I am using FM Pro Adv 13.  I have a database that is comprised of name, company, address, city, state, zip, and a few other fields.  There are multiple entires (i.e. name, address, city, state, zip) but I would like to only print 1 shipping label for each address.  I would also like to identify how many "duplicates" are in the database so I know how many items go in the box with one shipping label.

           I thought about creating an index made up of "name+address+city+state+zip", but I'm not sure how to create the count, not how to print just one label for multiple entries.

           Can anyone offer me suggestions or directions on how to do it?

           Thank you

           Elliot

            

        • 1. Re: Printing Shipping Label one time for multiple entries
          philmodjunk

               Sounds like you are trying to use one table where you need more than one table linked in relationships.

               A typical system for handling orders looks like this:

               Customers----<Invoices----<lineItems>----Products   (----< means one to many)

               with this setup, a given customer only has one record in Customers with the shipping address, but possibly many records in invoices--one for each order and each invoice can list multiple items for that single order.

               In most cases, you would then print one shipping label for each record in Invoices and not have an issue with duplicate labels.

               While the table names are slightly different, the Invoices starter solution that comes with Filemaker 11, 12 or 13 is designed on this basic data model.

          • 2. Re: Printing Shipping Label one time for multiple entries
            ejolesch_1

                 PhilModjunk -

                 Thank you for the input and I did think about that, but it may be overkill and very complicated to do.

                  

                 The list is created on the fly (originally) and this are one time only "event" customers.  They are receiving a photograph and because they have multiple groups at the event (each getting a photograph) I'm not sure how the Invoice Starter System would work.

                 Also, this list of customers [event leaders] will probably never be used again or at best once or twice per year.

                 If you still think the Invoice Starter is the best solution I will dig into it and take a look.

                 Thank you

                 Elliot

                  

            • 3. Re: Printing Shipping Label one time for multiple entries
              philmodjunk

                   I wasn't actually suggesting that you use the Invoice Starter, but that you examine it as an example of how this might be set up.

                   I was also trying to point out that you haven't really describe how you have set up and use your tables.

                   However you work out the final details the point is to set this up so that you do not have duplicate shipping address data in different records in the first place. Whether you ever use that data again once the event is over is not really part of my reason for making that suggestion.

                   It is possible to set something up that drops out the duplicates, but it's also rather complicated so I'd rather set up a More complicated design that is a better over all design, than a more complicated design built one what appears to me to be a less than optimum database design.