B
BillA
Wondering if it is possible to have a number of tabs that, when starting a
new record from within the tab - have a field contained in a common table
populated with the appropriate text corresponding to the tab.
As an example, say you have 3 tabs; Application, Renewal and Amendment. If
I was to use a common comment table for all 3, and decide to add a comment to
a record within the Renewal tab, a field within the comment table will be
filled with "Renewal" and the same would happen with the other tabs.
I am trying to consolidate and simplify tables and thought I could use a
common comment table to support the Application, Renewal and Amendment that
are tied (1:M) to a Project Table.
Any thoughts, advice, admonitions?
new record from within the tab - have a field contained in a common table
populated with the appropriate text corresponding to the tab.
As an example, say you have 3 tabs; Application, Renewal and Amendment. If
I was to use a common comment table for all 3, and decide to add a comment to
a record within the Renewal tab, a field within the comment table will be
filled with "Renewal" and the same would happen with the other tabs.
I am trying to consolidate and simplify tables and thought I could use a
common comment table to support the Application, Renewal and Amendment that
are tied (1:M) to a Project Table.
Any thoughts, advice, admonitions?