Hi Vince -

Crystal Reports can only report data, not write data back to CRE's or SQL database.  You can use access and write an update query if you must write data back, that field is ODBC writeable.

The employees default Certified Class is listed on the Entry Info Tab.  Not sure why you would want to replicate this same data in the Occupation field on the General Tab.

Cheers,

John McLagan
Independent Senior Consultant
Johnny on the Spot

Hi Vince -

Crystal Reports can only report data, not write data back to CRE's or SQL database.  You can use access and write an update query if you must write data back, that field is ODBC writeable.

The employees default Certified Class is listed on the Entry Info Tab.  Not sure why you would want to replicate this same data in the Occupation field on the General Tab.

Cheers,

John McLagan
Independent Senior Consultant
Johnny on the Spot

John,

Thats what I thought but wanted to verify. At some point in the past they decided to use the description of the certified class as the occupation, but also allowed data entry to enter whatever they thought the occupation should be so there are a great many inconstancies between the two fields, and they wanted to mirror them to avoid confusion.

Vince -

Sounds like it might be easier to delete them all and leave the field blank.  If you already have the data covered in another required field, I never suggest duplicated data for exactly the reason you are in right now.

Good Luck :)

Duplicated data is not necessarily a bad thing, Sage duplicates data all over the place, what would be helpful is a dropdown box (aka list) for the Occupation field so that the data comes in clean, instead of entries like (Laborer, laberor, Leyborer, Laberror, Laborers, Laborer1, labor1)