Hi All,

Hope you brains out there can help me with this one. I have a client that uses Ceridian's "HR/PR for DOS" (Ensemble) running on arev 3.02. The system has a relational index between the POSITION.NO field in the EMP file that is related to the EMP.NOS field in the POS.TABLE file. We had all set up and running nicely; then the VP of HR (as is their want) decided that we had to restructure the entire position tracking system; so I removed the relational index, cleared the POS.TABLE file and ran a program that cleared out all the EMP file position fields; and repopulated both the EMP and POS.TABLE data with programs in the proper new format. THEN I went to turn the relational index back on, entered EMP as the source filename and POSITION.NO as the source field name; and the POS.TABLE as the destination file name, but when I pressed ENTER off of the EMP.NOS destination field name I got a message saying that "a relational index already exists for file EMP1 and a relation may not be also built for the EMP fil

e". Too Wierd, since there is NO EMP1 file attached or on *any* of the media available to the system. I tried removing ALL the EMP indexing and rebuilding the btrees, but yet again when I tried to add the relational index I got the same thing. MY QUESTION IS: I am supposing that there is a RECORD somewhere in some FILE that the relational WINDOW looks to when I press enter off of the field name in order to give me that error message. What record is it, and can I get rid of it so that the system no longer thinks that there is an index on the EMP1 file???

HELP. Twelve years working with revG/arev and I've never come across this one before, and of course Ceridian is no help whatsoever….thanks for you time and at least for getting this far in the message.

Tom

Referebces will be in several places, to whit :-

 In the !File in the !File row

 In the !File in the A*B*C row

 In the other !File in the !File Row

 In the dictionary of the from and to dict items

try them and if no luck revert.

amcauley@sprezzatura.com

Sprezzatura Ltd

World Leaders in all things RevSoft

Check field 23 of the EMP.NOS dictionary record in the POS.TABLE.

There should be information relating to the old relational there.

akaplan@sprezzatura.com

Sprezzatura, Inc.

View this thread on the forum...