Table copy and overwrite combinations
When you copy a table or layout and overwrite an identically named table in AX Server, there are a number of possible results based on the source table type and the paste option.
Possible combinations
| Copied table | Overwritten table | Result |
|---|---|---|
|
Standalone table |
Standalone table |
Standalone table |
|
Master table |
Linked table |
|
|
Shared table (one) |
Shared table (one) |
|
|
Shared tables (more than one) Note If a user copies multiple shared tables and overwrites a single table, such as a standalone table, only one of the multiple shared tables is involved in the overwrite operation. |
Standalone layout |
|
|
Linked layout |
||
|
Master table |
Master table |
|
|
Master layout |
||
|
Shared tables (more than one) |
Standalone tables (more than one) |
|
|
Standalone layout |
Standalone table |
Standalone layout |
|
Master layout |
Linked table |
|
|
Shared table (one) |
||
|
Standalone layout |
||
|
Linked layout |
||
|
Master table |
Master layout |
|
|
Master layout |
Copy and overwrite rules
| Copy > Paste | Overwrite | Result |
|---|---|---|
|
any table or layout type, except for a linked table or layout |
any table or layout type |
content of overwritten table (layout + source data file) or layout replaced by content of copied table or layout |
|
a standalone table or layout |
always a standalone table or layout |
|
|
a master table or layout |
always a master table or layout |
|
|
a linked table or layout |
always a standalone table or layout, previous linking relation ceases to exist |
|
|
a shared table |
always a standalone table or layout, previous sharing relation ceases to exist |
|
|
a master table or layout |
a master table or layout |
linking relations of overwritten master stay in place |
|
a linked table or layout |
overwrite disallowed |
additional link to master, incrementing number appended to linked table or layout name |
|
any table type, except for a linked table |
any table or layout type |
always a table |
|
any layout type, except for a linked layout |
any table or layout type |
always a layout |
|
a standalone or master table (layout + source data file) |
overwritten table replaced by copied layout, source data file deleted |
|
|
multiple shared tables, one of which overwrites an identically named table or layout |
any table or layout type, except for a master table or layout |
multiple standalone tables, one of which is overwritten |
|
a master table or layout |
multiple tables, one of which is overwritten and remains a master |
|
|
multiple shared tables, any number of which overwrite identically named tables or layouts |
multiple shared tables |
multiple standalone tables |
