AnsweredAssumed Answered

Creating multiple records automatically

Question asked by russk68_1 on Feb 24, 2010
Latest reply on Mar 12, 2010 by philmodjunk


Creating multiple records automatically



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