I need advise on the best way to handle the following problem:
I have a database that contains a many to one relationship. There are multiple radio types, each represented by a table. Each type of radio has different attributes associated with it. These radios are tied to an antenna table. The common tie or key between the tables is a radio serial number. Here is the problem. When the radio serial number is entered into a radio table via a form, I need a record created in the antenna model populated with the readio serial number simultaneously. In other words, there need to be some kind of dynamic link between these the radio tables and the one antenna table via the radio serial number.