Hi anyone who can help. I need a way to display a view to show products at parent level with a list of who has that particular product shown in the child view. At the moment I have products setup so that the user can see what they have in stock but I want to be able to show the product and who else has it in stock? I have some tables Products, Employees, Stock in, Stock Out. I want a way to display the employee who has that particular part in stock shown in the child view of the products table?
So it would kind of look like this
Parent = [Product name]
Child = List of [Employee names] and [Stock level]