AnsweredAssumed Answered

Populate Primary Key when child records are imported first

Question asked by DennisFlight on Jun 24, 2015
Latest reply on Jun 24, 2015 by philmodjunk

Title

Populate Primary Key when child records are imported first

Post

I have a solution with 2 tables the child table called Race Data and the parent table called Races

everyday i import approx 150 records into the child table and of those 150 records approx 12 to 15 are related by the date track and race # (ex. 13 players in race 1 at certain track on a specific date)

What i would like to do is auto create records in the parent table so the portal shows all the players for each race

Relationship is between primary key and foreign key

Here is a link to a similar issue Creating Parent Records from Child Table/Layout/Record

Child table                        Parent table

::Foreign Key                    ::Primary Key (Serial Number)

::Date                                 ::Date

::Track                                ::Track

::Race #                             ::Race #

::Player Name

::Player #

One solution i have managed to get to work is to use a calculation field  combining date-track-race# as the id in race data and do the same in the races table..... but i would much rather use the serial numbers for safety.

Thanks

Outcomes