Help with Parent child relationship

[AntonyCole1979]

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]

thanks

Antony

[Aleksi]

I’m afraid that’s not possible directly with an action button. Though you could do that with an API.

[AntonyCole1979]

Thanks @Aleksi

[Fabio_Nabuco_Co]

Dear all;

Is there a way to set an action that changes the value of mother table with the value of a child form?

For example, I have a table with my current stock.

I’d like to change the value of the stock every time a new expedition is input in the system. I’ve seen examples with static values, but not yet the value of a form.

In advance, thank you.

Regards;

Fábio