Editing Joined Data
Concept Procedure Quick Reference
 
 
 

To edit joined data

For this type of join or data... Edit Insert Delete
One-to-One You can edit the primary table (the native feature data) when you display the Data Table for the feature layer. To edit the secondary table (joined data) open the table in Map Explorer. You cannot edit the primary key, but you can edit the join key. You cannot insert data for an inner join because it might cause the new primary record to “disappear” when there is no matching secondary record. For a left outer join, you can insert records only in the primary table. You can delete only records only in the primary table.
One-to-Many You cannot edit the primary table (the native feature data) or the secondary table (joined data) in the Data Table from Display Manager. Instead, open the tables in Map Explorer. Not available. Not available.
Offline You can edit (as above) while you work offline, but you cannot insert records. Not available. You can delete only records only in the primary table.
Feature data You can edit read/write feature sources. You can insert data for read/write feature sources. You can delete data from read/write feature sources.
ODBC data table You can edit records in Data Table. Not available. Use the source application, such as Microsoft Access, to insert records. Not available. Use the source application, such as Microsoft Access, to delete records.