1 Reply Latest reply on Aug 2, 2014 11:30 AM by philmodjunk

    displaying serial # from one table into another

    SeanSarjoo

      Title

      displaying serial # from one table into another

      Post


           Im working on database for a non-profit.. currently every exam has its own exam# and every lab has its on subject# I need to have the exam# increase every time i add a new exam, then need to select a lab and every time i add a new subject# i need to also display the current exam#

           any help would be appreciated

            

        • 1. Re: displaying serial # from one table into another
          philmodjunk

               It's very hard to answer a question based on such limited information. My answer thus may not work for you due to that lack of information.

               In FileMaker, you can set up a field to auto-enter serial numbers. Each time you create a new record, a new unique value is entered into this field and it's the next number in the specified series. So if you have a table of exams with one record for each exam, an Exam Number field can be set up in this table using field options that auto-enters a serial number for you.