On Center Home | MyOnCenter Portal | Start an On-Screen Takeoff Trial | Request a Quick Bid Demo | Contact Us | SALES: 1-866-627-6246
   
 
Learn more about Searching
Looking for help for one of ConstructConnect's Other products? Login


Tools
Table of Contents

Quick Bid - 04.01 Finding and Replacing In-Use Records So You Can Delete a Master Record - QB

Views: 925 Last Updated: 10/31/2024 01:08 pm 0 Rating/ Voters
Be sure to rate this article 5 Stars if you find it helpful!

Most Master Records cannot be deleted if they are in use. "In Use" means the record has been used in a Bid (such as an Estimator or a Job Status) or is used in another Master record (for example, when setting up an Item, you will likely use an Item Type.

After you use many Master records in a Bid, they cannot be deleted from the Master list (exceptions: Items, Payroll Classes, and Assemblies). Sometimes, an estimator will add something to the Master such as a Job Status, Item, Condition Type, or Container, that then realize they do not need (we've seen databases with Containers named: boxes, box, boxx, boxs, etc. - only one of those is needed, the rest are erroneous entries). The problem is, if you do not know in which Bid, or related Master record, something has been used, it is nearly impossible to delete it from your database. For example, if one of your estimators added an Item that was setup using "boxs", for example, you'd have to find that Item and correct the mistake, but if your database contains 5,000 Items, that could take a very long time.

Items are a little different - because they can be used in different ways in the Masters, we provide a tool to locate all the records you need to update before you can delete an Item. See Related Articles for details.

Deleting Records if they are "In Use"

Quick Bid provides two tools to help you manage your Masters. First is "Global Find and Replace" (covered below), which allows you to get rid of unwanted records in some of your Master Tables. The second is called "Show Where Used" (see Related articles). "Show Where Used" is specific to the Master Items table. Because an Item can be used in another Item (in a Chain or as a component of a Mixture), or in a template (Condition Assembly).

Find and Replace

Several Master Tables include a "Global Find and Replace" function that lets you replace a specific record, anywhere it is used in the Database, with an different record (for example, I can 'find' every instance of 'boxx' and replace it with 'box'). Once you've replaced it, you can go back and delete the original record. This is also convenient if you want to globally replace a Manufacturer on all Items - let us say, you decide you always want to use "Armstrong" as the Manufacturer instead of "CertainTeed" (or vice versa) - you can use the replace function to update all Items where Manufacturer was "Armstrong" with "CertainTeed". There is also a function on the Materials Tab named named "Replace Material Where Used", but that only swaps one Material Item for another in that Bid.

Caution

Using Find/Replace affects all Master records and all existing Bids If you do not want to change existing Bids, you would need to create a new database, synchronize (old to new), do your Find and Replace in the new database, then synchronize back (new to old). Only Master records are affected by synchronizing databases, not existing Bids. See Related articles for information about synchronizing databases. You will not be able to delete the erroneous record from the 'old' database, however, because it will still be 'in use' in those existing Bids.

Quick Bid Master menu highlighting the lists that support find and replace

The Contact Types, Item Types, Manufacturers, Containers, Job Types, and Condition Types dialog boxes include a "Replace" button.

Quick Bid Master Job Statuses dialog box showing the Replace button

When you highlight a record (such as "Hospitals" in our example) and try to delete it, you are presented with a warning dialog that informs you that the entry cannot be deleted because it is "in use". We want to delete "Hospitals" because, essentially, it is a 'duplicate' of "Hospital" and is not needed.

Quick Bid error notification that a master record cannot be deleted because it is in use

Quick Bid allows you to Replace the use of "Hospitals" with "Hospital" everywhere it is been used in the database.

Click OK to close the warning box, back in the Master dialog box, highlight "Hospital" in the list and then click the Replace button, the Find and Replace (Globally) dialog box opens:

You can replace one Master record with another in some cases

Select what you want to replace in the top box, in this case, "Hospitals" (whatever was highlighted in the list when the "Replace" button is clicked is set as "Replace what" automatically, but you can select something else).

Click the "Replace with:" drop down and you are presented with all possible replacements from the Master list (of whatever you are trying to replace, in our example, Job Types):

In the Find and Replace dialog box, you select the record you want to replace and what you want to replace it with

Select one and then click Replace - every instance of "Hospitals" is replaced with "Hospital" in the database.

Now that "Hospitals" is no longer in use, you can go back and delete it from the list.

Note
Using the Global "Find and Replace" function changes all Bids and any Master record that used the previous entry - they are all updated to the corrected selection.

Changes made at the Master level are immediate and permanent. Proceed with caution when deleting entries from the Master menu lists - these deletes cannot be undone.

Each Master Database Table is detailed in the articles that follow, starting with Contacts and Contact Types.

click here to view the previous article What are "Masters" or Master Tables? What are Contacts? click here to view the next article



Product documentation (user guides) describes functionality in the latest version of each major release and may not match the functionality in the version you are using. Please check the Product Information and Downloads pages by clicking one of the product buttons above.

Something Wrong with this Article? Let us Know! The information in this site is protected by copyright by ConstructConnect. You may not reproduce, adapt, or publish any content from this site in whole or in part for any purpose, without the express written consent of ConstructConnect, Inc.
Copyright 2024 - All Rights Reserved.