How Can I autopopulate 'Location' Reference field with same value as shown in Space Reference field

[WazzaJC]

How Can I auto-populate 'Location' Reference field with same value as shown in Space Reference field

Hi Guys,

I have built a few Reference fields, Building (u_building), Floor (u_floor) and Space (u_space) field on my Incident Form (see screenshot attached). These are all Reference fields.

These are all driven/referenced directly from the Location (cmn_location) table.

I also have the standard 'Location' field, which also references the Location table.

How can I write either a script or business rule, so that when the Space (u_space) field gets populated with a location value, at the same time the Location (location) field will then also get updated with the same location value, that is referenced within the 'Space' (u_space) field ?

I assume this is either a Business Rule or perhaps onChange Client Script?

Please see my screenshot attached, showing the relevant fields.

I would appreciate any help/guidance with achieving this.

Many Thanks.

[WazzaJC]

Thank You Sai, I will try this out.