Search found 5 matches
- Mon Mar 25, 2019 3:23 pm
- Forum: Standard/Enterprise Development
- Topic: SQL Query Help
- Replies: 7
- Views: 4872
Re: SQL Query Help
I'm starting to get the impression that a lot of what I'm looking for is stored in the physical PFD for the FirmFile and not in the database.
- Mon Mar 25, 2019 3:21 pm
- Forum: Standard/Enterprise Development
- Topic: SQL Query Help
- Replies: 7
- Views: 4872
Re: SQL Query Help
Next stumper... Parcel ID number? I have access to the Brief Legal description (BLegal), but need to be able to query on the Parcel ID.
- Mon Mar 25, 2019 2:24 pm
- Forum: Standard/Enterprise Development
- Topic: SQL Query Help
- Replies: 7
- Views: 4872
Re: SQL Query Help
So this is the situation I'm running into, from a lookup perspective... On the Search table, it stores in the LenName field the Name1 from the Lender lookup. Unfortunately there are about 10 rows in the Lender Lookup that all have the same Name1. How do you determine which LENDER.CODE or LENDER.ID w...
- Mon Mar 25, 2019 2:13 pm
- Forum: Standard/Enterprise Development
- Topic: SQL Query Help
- Replies: 7
- Views: 4872
Re: SQL Query Help
Thank you for the information.
- Fri Mar 22, 2019 10:27 am
- Forum: Standard/Enterprise Development
- Topic: SQL Query Help
- Replies: 7
- Views: 4872
SQL Query Help
New to the forum and new to SoftPro. Working on an ENT 31.0.2 version. I'm trying to develop a SQL query to extract information from SoftPro so that it can be used with an iManage Work DMS. The biggest issue I'm having is the lack of relational links between tables/databases and finding unique data....