Same Entry in Multiple Tables

[RangerFrank]

I have a DB "Medical Escorts. I have 3 tables.

1st Table: Medical Escorts.

2nd Table: Itinerary.

3rd Table: Documentation.

Each table has "RNME Control Number" as the first entry. I established a relationship with RNME Control Number in all three Tables. I use control numbers RNME 2008-001 using the Auto-Enter --> Serial Number --> Next Value:

"RNME 2008-001" --> Increment by "1". Auto-Entry works fine by entering in 1st Table, but does not enter RNME 2008-001 in the 2nd & 3rd Tables.

[color:brown]I want to be able to place the control number in Table 1 and have the same control number simultaneously placed in Tables 2 & 3.

I have tried to figure this out by using FileMaker Pro The Missing Manual.

Thanks, Frank

[Fitch]

Hmmmm. Normally each table would have its own serial number, known as its "primary key" field. The field used in the related "child" tables to relate to the "parent" table is called the "foreign key" and you would NOT auto-increment a serial number for that field.

If you set up the fields that way, and your relationships to Itinerary and Documentation are set to allow creation of related records, and if you have portals to those tables on the Medical Escorts layout; then simply entering data in a field in the portal will enter the primary key of Medical Escorts into the foreign key field of the other tables.