--- title: "Managing the \"Shire\" dropdown menu in SQL." canonical: "https://servicedesk.maxgeo.com/space/LC/1263501394/Managing%20the%20%22Shire%22%20dropdown%20menu%20in%20SQL." format: markdown --- **Objective:** Get the "Shire" dropdown menu populating with the correct Contacts. **Before you start:** The SQL Database should only be accessed by appropriately trained and qualified SQL professionals.  If your IT or DBA team are not available to assist, please contact servicedesk.maxgeo.com for assistance.  No changes should be made to the SQL Database directly - all changes should be through the LeaseControl software or via our staff at [sales@maxgeo.com](mailto:sales@maxgeo.com) **Troubleshooting:** - From SQL Management Studio, open the table "dbo.LMS_CONTCT_Contact", and filter the "CONTCT_ContactTypeID" for 8. - If there is no table by this name, refer **Problem 1**. - If the list contains Contacts that are not in the User's LeaseControl (refer CONTCT_DisplayName), refer **Problem 6**. - If there are all the Contacts the User can see, plus more, refer **Problem 7**. - From SQL Management Studio, open the table "dbo.LMS_CONTYP_ContactType". - If there is no table "dbo.LMS_CONTYP_ContactType" refer **Problem 1**. - Look for CONTYP_ID 8. - If there is not CONTYP_ID 8 refer **Problem 2**. - Advise the User this is the Contact Type they need to use to populate the "Shire" dropdown menu. - If this has been renamed something completely different refer **Problem 3.** - If the user doesn't know what to do, refer **Problem 4.** - If the user can't see this option in the "Contact Type" dropdown menu refer **Problem 5.** **Problem:** 1. This is not a LeaseControl database.  Refer **Solution 1**. 2. This is a non-standard library.  Refer **Solution 2**. 3. Somewhere along the way, a User has changed the name to something they don't recognise as fit for this purpose.  Refer **Solution 3**. 4. This is a training issue, not an IT issue.  Refer **Solution 4**. 5. Somewhere along the way, a User has deleted it.  Refer **Solution 2**. 6. This is not the same database that the User is looking at.  Refer **Solution 1**. 7. The new data has not been pulled through to all LeaseControl screens.  Refer **Solution 5**. 8. The new data has not been pulled through to this particular LeaseControl install.  Refer **Solution 6**. **Solution:** 1. Open up the (correct) LeaseControl database.  If you unsure which one it is, refer to the related article "What SQL Server / Database am I using?" 2. Email [sales@maxgeo.com](mailto:sales@maxgeo.com) for assistance. 3. Within the software: - Rename this Contact Type in the software to "Shire" or something similar (e.g. "Local Government") from the "Contact Type" Library. - Create a new Contact Type in the "Contact Type" Library for this other purpose (e.g. "Landholders"). - Change each relevant Contact to the new Contact Type (e.g. "Landholders"). - Change each relevant Contact that was meant to be in the dropdown menu to CONTYP_ID 8. - If there are too many Contacts for the above to be practical, please contact us at [sales@maxgeo.com](mailto:sales@maxgeo.com) to obtain a script to run. 4. Refer to the Related Article "The drop down menu isn't populating correctly" (specifically, Problem 1). 5. Refresh the grid.  If this doesn't work, refer **Problem 8**. 6. Refresh LeaseControl.  If this doesn't work, keep Troubleshooting. **Additional Info:** - *I don't know which database they using and/or where it is located**.* Refer to the Related Article "What SQL Server / Database am I using?". - *How to I 'refresh' the gird?* If one of the following doesn't work, try the other: - Right-click on the header row of the grid, and select 'refresh'. - Close the record (the small "x" at the top-right of the screen, then reopen the record. - *How to 'refresh' LeaseControl?* If one of the following doesn't work, try the other: - Close the record (the small "x" at the top-right of the screen, then from the "Tools" menu, select "Refresh". - Exit LeaseControl and reopen.