Deleting an item from TISS28.accdb: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
m (Text replacement - "TISS28.mdb" to "TISS28.accdb")
m (Ttenbergen moved page Deleting an item from TISS.mdb to Deleting an item from TISS28.accdb without leaving a redirect: Text replacement - "Deleting an item from TISS.mdb" to "Deleting an item from TISS28.accdb")
(No difference)

Revision as of 12:09, 2020 June 5

This page explains how to delete an item from TISS28.accdb after import, usually once it is found by one of the [[]]s. See Deleting a duplicate record from the TISS pre-import file about records that give errors during the import.

Instructions

  • in the navigation panel on the left side of TISS28.accdb, find and open L_TISS_Item table
  • Right click on the D_ID column
    • Select Text Filters and click on Equals. Custom filter text box will appear.
    • Enter the D_ID and click ok. This will filter to all the Tiss data for this D_ID.
  • Select the row you want to delete and right click and select delete record.
    • You have a text box stating that your about to record one record. Click Yes.
  • Close out of the L_TISS_Item table.

Rare

This is relatively rare, so we decided it was not worth making queries as in Fixing a D ID in TISS28.accdb.

Related articles

Related articles:
Retrieved from "https://ccmdb.kuality.ca/index.php?title=Deleting_an_item_from_TISS28.accdb&oldid=144619"