A client asked: How do I know how many records I have?
If you ever wonder how many primary contacts, secondary contacts, or history items you have in your GoldMine database, there are simple SQL Queries to give you a count.
* First, go to Tools > Filters & Groups > SQL Queries Tab
* Copy and paste the queries into the top half of the screen
* Then click the Query button
For a count of primary contacts:
Select count(*) from contact1
For a count of secondary contacts:
Select count(*) from contsupp where rectype = 'C'
For a count of history records:
Select count(*) from conthist