Auto populate based on table selection

Cat
Tera Guru

Hi Everyone,

 

Really hoping you can help with this as I am well and truly stuck!

 

I have a catalog item that has a number of lookup select boxes based on a table. I have 3 other fields on that table, which I'd like to auto-populate based on the lookup select box selections:

Cat_0-1747761210786.png

The business area field shows only those in the table related to the client company, and the role profile gives options based on the client company and business area.

 

I'd like to auto populate three additional fields (Role Name, Database, Dataserver Name) with what they are per the table.

This doesn't appear on autocomplete as they are lookup select boxes rather than reference.

 

Does anyone have any ideas as to how I can do this?