I have ended up with BIG Problem. I have two ...

(Sarens Nass Middle East) #1

I have ended up with BIG Problem. I have two Tables one is Equipment with its Models and another one is Operators details with Equipment Models, on which they are certified. The Equipment Models for Operators are multi select in nature. So i manually added all Equipment Models by Enum list, so that user can choose multiple models.

Now, they are looking for Equipment Model wise Operators. It means i need to add a virtual column in Equipment Table as a ref_row from Operators.

How i can achieve this?

BIG Thanks in Advance.

(Yılmaz Kandiş) #2

If only simple view is enough for you, then why not you create a new table view based on Operators and “Group By” the view per Operator so you can drill down to Equipments used by each operator.