I'm looking for help with a couple of table relationships in an order system for a radio network.
Tables are ORDERS & STATIONS
When a new record is created in ORDERS, and a particular STATION is selected based on the table relationship, it will lookup CITY OF LICENSE.
Occasionally an order will broadcast in more than one city so I need the option to select multiple STATIONS, and lookup the appropriate CITY OF LICENSE of each, but keep it in one order record.
Thanks for your help.