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.
User | Count |
---|---|
37 | |
30 | |
29 | |
22 | |
18 |