10 Replies Latest reply on Mar 12, 2010 4:41 PM by philmodjunk

    Creating multiple records automatically

    russk68_1

      Title

      Creating multiple records automatically

      Post

      Example:

      I have a table were I would enter a floor # in a hotel. I have another table that would automatically create the 6 rooms on that floor. (Always 6 rooms)

      I would like the following to happen:

      1 Enter a floor # in a field on the "floor table"

      2 The "room table" would create 6 records, Room#1,Room#2...Room#6. (Always creating 6 new (room) records for every floor (Record) created.

       

      Floor Table              Room Table

      Floor 1                    Room #1

                                   Room #2

                                   Room #3

                                   Room #4

                                   Room #5

                                   Room #6

      Thanks in advance!

       

      Russ Keitel

      www.technolite.com