Linking two fields on different tables

[Nikita35]

Hi All,

I have created new field 'Owner' on the Schedule Entry table.

I want to link this field with 'Owner' field on Events List [u_maintainance_blackout_change] table.

That means whatever I am selecting the owner in one table should reflect in the other table and vice versa.

Please advise on this.

Regards,

Nikita Khavnekar

[anurag92]

Create 2 update BRs on both tables with condition as Owner changes.

then glide u_maintainance_blackout_change table and update the owner field as:

gr.owner = current.owner;

gr.update();

[Nikita35]

how will it link two tables?

[anurag92]

Oh is there no common field between these 2 tables?

[kalyan778]

HI Nikita,

Instead of creating new fields in 2 tables,can't you use the dot walking method on the other table.

1.Lets say create owner field on the scheduled entry table.

2Create a new field scheduled entry (refferenced to schedule table)on the Events List [u_maintainance_blackout_change] table.

3.using dot walking get the owner field to the layout.

Let me know if you need help in this.

Thanks