How can I achieve this? Two Tables 1. Equipme...

(Sarens Nass Middle East) #1

How can I achieve this? Two Tables 1. Equipment Directory (Unit Code, Status, Till Date) 2. Booking (Date, Sales person, Unit code). In Unit code, i am using Enumlist from Equipment directory. At last, i want to see as per below Interactive Dashboard. When i select left hand side, equipment code, system should show is there any booking on right hand side. The problem is here, i am using Enumlist, since there should be more than one equipment booking.

Any Advise please.

(Aleksi Alkio) #2

You should have a relationship (ref) between these two tables. I assume you don’t have?

(Sarens Nass Middle East) #3

@Aleksi_Alkio No… don’t have any relationship…

(Aleksi Alkio) #4

If the Unit code field would be a

ref column (on Booking table) it would work, but then you could only select one record.

(Sarens Nass Middle East) #5

@Aleksi_Alkio Yes…I thought so… thanks sir