I have a table with Parking Lots and a new child table with drainage catch basins within those Lots. Each lot has a unique number that is not the record ID# (key field) and I cannot, for a number of reasons, make that Lot Number the key field. Anyway, all of the catch basin records are a csv file import and the Lot Number is part of those records. Using a report link works to show the catch basins under each parking lot, but I need to create a Related Lot numeric reference (the Lot's record ID#) for each of the catch basin records. There are 189 lots and 305 catch basins so I need a way to get this done by formula or something.