FAQ-1451 Build Dept (dept.dbf) from Stations (line1.dbf)

From the ToolBox Utility type these commands:

CLOSE DATABASES
SELECT DISTINCT department FROM LINE1.DBF INTO TABLE DEPT_LIST.DBF
CLOSE DATABASES
USE DEPT_LINE.DBF
MODIFY STRUCTURE 

Change the name of the department field to "NAME"
Press CTRL-W to Save
Back at the toolbox utility. 

CLOSE DATABASES
USE DEPT
ZAP
APPEND FROM DEPT_LIST.DBF
BROWSE NORMAL 

Check that the department names are showing in the name field.

Start Call Accounting and check that the department codes are showing in the department pull down windows.

 

 

Comm One LLC Technical Support
138 E 12300 S Ste #C102
Draper, UT 84020
385-529-5819
[email protected]

Contact Comm One
Visit the Comm One Call Accounting Web Page

Last Reviewed: 02/02/2017

Have more questions? Submit a request

0 Comments

Please sign in to leave a comment.
Powered by Zendesk