How do I select multiple items that can only be used once? ie: Tickets on an invoice

Hello, I have the following Tables: Employees, Time, Tickets, Invoices. 

Multiple Time entries can go on one Ticket and multiple Tickets go on one Invoice. 

I would like to be able to select time entries from within the Tickets view with an Enum List. And the same for selecting the tickets into an Invoice. These items would only be used once. 

I would like the TicketID to go in the TicketID column of the Time Records and the InvoiceID to go in the Ticket Records. 

I can do this one at a time with type Ref and is part of  but how can I accomplish this as an enum list?

 

 

0 5 389
5 REPLIES 5
Top Labels in this Space