Z:\WORK\BLANK.MDB Tables (2/8/2018 1:28:14 PM) | ||
tblCombo 3 recs | Values for combo boxes PK: +Combo;+Code | |
Combo | T 20 | Name of combo box |
Code | T 5 | Value returned by combo box |
Descrip | T 50 | Long description that appears in combo |
Sort | 6 | Sort order for combo |
Sel | Y/N | Yes=Select this record for processing |
Comment | T 255 | Note about this record |
Usr | T 8 | User who last updated this record |
UpdDate | Date | When record was last updated |
tblContact 1 recs | Info about contacts PK: +ContactID | |
ContactID | Long | Primary key |
LastName | T 20 | Last name of contact |
FirstName | T 15 | First name of contact |
Company | T 50 | Billing name of company |
Street | T 50 | Street address of contact |
City | T 20 | Citry of contact |
State | T 2 | State of contact if USA |
Zip | T 10 | Zip/Postal code |
HomePhone | T 14 | Home Phone number of contact |
CellPhone | T 10 | Cell phone number of contact |
WorkPhone | T 14 | Work phone number of contact |
T 50 | Contact's email address | |
Inactive | Y/N | Yes=Contact is no longer active |
Group | T 50 | Marketing Group |
Comment | T 255 | Note about this contact |
Sel | Y/N | Yes=select this record for processing |
Usr | T 8 | UserID of person who last updated this record |
UpdDate | Date | Time record was last updated |
tblDI 2 recs | Data Integrity queries PK: +DIQuery | |
DIQuery | T 100 | Primary key |
DIRecs | Long | Count of recs in query |
Sort | 6 | Sort order of query |
Fix | Y/N | Yes=Fix w/qFix... |
Note | T 255 | Copyright Agee Software, Inc., 2008 |
Comment | T 255 | Text on how to Fix problems |
Tbl | T 20 | Table to open upon Sel |
UpdDate | Date | When record was last updated |
tblEval 4 recs | ||
EvalID | Long | Primary key |
PatientID | Long | Relates to tblPatient |
Group | T 50 | Please select a Group |
EvalDate | Date | Date of eval. (m/d or m/d/yyyy. DblClick for today. Num */- to add/subtract a day) |
Complete | Y/N | Yes=Eval is complete |
Sel | Y/N | Yes=Select this record for processing |
Comment | T 255 | Note about this record |
Usr | T 8 | User who last updated this record |
UpdDate | Date | When record was last updated |
tblReport 1 recs | Report menu PK: +ReportName | |
ReportName | T 50 | Primary key. Access report object name |
ReportTitle | T 50 | Title of report in combo |
Sort | 6 | Sort order. 1.2 is between 1 and 2. |
UpdDate | Date | When record was last updated |
tblSetup 1 recs | ||
SetupID | Long | Primary key |
Company | T 50 | Name of company |
Street | T 50 | Company street for mailing address |
City | T 20 | City in which Company is located |
State | T 2 | State in which Company is located |
Zip | T 10 | Zip code for company |
Phone | T 14 | Company phone number |
Fax | T 14 | Company Fax number |
Website | T 50 | Company website |
T 50 | Company email address | |
ImportFolder | T 50 | Folder where files are stored for import/export |
ColorUsr | Long | Form color for normal user |
ColorSuper | Long | Form color for super user |
Quit | T 255 | Message for users when super issues a forced quit command |
Ver | 6 | Latest version of front end available for download |
Usr | T 8 | |
tblUser 2 recs | Info about users PK: +UserID | |
UserID | T 8 | Primary key |
UserName | T 20 | First and last name of user |
T 50 | EMail address of user | |
Phone | T 14 | Phone number of user |
Comment | T 255 | Text about this user |
Super | Y/N | Yes=User can add/remove users |
Limited | Y/N | Yes=User has read only access |
Usr | T 8 | User who last updated this record |
UpdDate | Date | Time record was last updated |
7 tables© 2008, Agee Software, Inc. |