2 Replies Latest reply on Feb 9, 2010 5:58 AM by daveealex

    Tracking Number

    ian37

      Title

      Tracking Number

      Post

      Hi I have a record with Name, Payment_date and Payment_ number.

      When a person gets paid the payment date is inserted next to their name.
      I need a script to insert a number starting at one in the payment_number field.

      So now we have their Name, payment date and payment Number.

      If I now make a new record, may be days later and use the same person again when they get paid I want it to insert 2 into that records payment_number field.

      So every time they get paid the number is incremented by 1 on that record related to that persons name. This must work for other people in the database as well.

      Any ideas? Thanks





        • 1. Re: Tracking Number
          daveealex
            

          ian37,

           

          I am new also to filemaker but i will try to help. What i would do is create 2 databases. One with the personal info and one with the payment information. Connect them via a relationship. Then i would use a portal that would show up in the personal info page of that person. From this portal you can add records to the payment information database if you have this option selected when you create the portal. About the auto-increment number of payments it wont really be a problem because you can see all the payment history on the same page, so you can add it manually without error. This is only a little idea i had for you database. I am sure there are some better ideas to come along soon. Good luck!!

          • 2. Re: Tracking Number
            daveealex
              

            Ian37,

             

            if you need more indepth instructions let me know and i will give you more information. 

             

            Dave