Hmmm....that sounds like a huge undertaking but I do need to have that relationship. Since both tables have the Parking Lot Number isn't there a way I can maybe place in the Parking Lot table a formula field that says if the record has Parking Lot Number 1234 then [Record ID#]? Then someway in the Catch Basin table have the same Parking Lot Number 123 translate to that [Record ID#] and use it to relate the records? Hope that makes sense. I'm having a lot of trouble with relationships in this huge application and have placed a number of postings with no good results yet. This one is only one of the recent issues but also one the simpler.
The other problems involve multi level relationships where I need to relate records back up about 3 to 4 generations. But that is for another day.
