Click Setup on the Main menu to see the Setup form.

Real Estate Buying and Selling program in Grand Prairie and Frisco, Texas

Enter your company's contact info.

To see the raw data in any table, select it in the Table combo and click the blue View link. You can sort or move columns. When you close the table, don't save. You can export tables to CSV, DBF, HTM, MDB, RTF, TXT or XML formats.

TblDoc creates an HTML data dictionary that describes the fields in each table.

Clicn User to open the User form. Super users can add or delete other users.

More info on setting up users

Link specifies the location of the data tables. It may take a couple minutes to relink the tables.

To back up your data tables, click Backup and specify the file location.

Click Quit to force users out of the database for maintenance.

Compact is similar to defrag for your hard drive. It removes deleted records and rebuilds indexes in your data tables.

Note lets you add notes not related to a property, contact or listing.

Feature form for Realty application

Click Feature to edit the property features desired by a contact.

Show Assistant form for Realty database

Click Show Assistant to log when showing assistants show a listing.

Real Estate application for Tarrant, Denton, and Dallas counties

Click Combo to open the Combo form. Super users can add or change the values that appear in combo boxes throughout the system. The Code field is required as a primary key for for each record.

Combos include:
  • City
  • ContactType
  • FoundUsHow
  • Group
  • ListingAgent
  • LogType
  • LWTC
  • PersonResponsible
  • Priority
  • PropertyType
  • School
  • ShowingAssistant
  • Status
  • Subdivision
  • Task
  • TransactionType
Data Integrity for realtor database for Collin and Denton counties in Texas

The Data Integrity form helps you keep your data complete and accurate without slowing data entry because the data wasn't currently available. It is easy to create dozens of these queries in an hour, so any time you encounter a data entry problem, we can create a DI query to avoid it in the future. Each query has a line describing what the records represent and a line describing how to fix the problem. Click Calc to count the number of problem records for each query. Calc1 counts the problem records for the current query. SQL shows the raw SQL statement for the query.

Sel selects the problem records and opens the appropriate form so you can scroll through and fix the records. Export lets you save the problem records as an Excel XLS, CSV, TXT or other format. View shows the problem records read only. If problems in a query can be fixed using automated rules, you may see a Fix button that confirms and then fixes the problem records.