AnsweredAssumed Answered

Multiple Answers in a lookup field

Question asked by fscales on Feb 4, 2016
Latest reply on Feb 4, 2016 by fscales

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. 

Outcomes