Dynamic dropdown list based on lookup function

Dynamic dropdown list based on lookup function

Hi,

When booking a deal I input Account which orders my product, however the accounts have daughter companies under which the deal is booked under.

I have created a seperate module called Registered entities with the names of the daughter companies as well as a lookup for the parent account.

In my deals, when I choose a lookup of the account under the deals is booked i want to make a dropdown of all the registered entities associated with this particluar account, is there a way to do this?

kind regards
Michael