Question

Validation or business rule on Tue, 08 Jan 2019 04:02:28


I have an entity I am using as dropdown in my main table, ie code I have as staff members name then additional columns are:

* TEAM NAME

* TEAM LEADER

* TEAM HOURS

I then in my main table Staff stats have:

* STAFF NAME (which I pick from dropdown of table above we call this table XREF_TEAM

* TEAM NAME (Thought business rule I have it as defaults to XREF_TEAM.TEAM NAME)

The issue I am having is if the XREF_TEAM table is updated ie the STAFF NAME team member changed teams so XREF updated it is not automatically updating in main table.How do I get this to work.

Cheers

LIsa