If this is not possible what would the best way to accomplish this?
I have the Certified Class description i want to assign to the Occupation field on the Master Employee Record, we would like them to match and currently they do not.
Thanks
V
If this is not possible what would the best way to accomplish this?
I have the Certified Class description i want to assign to the Occupation field on the Master Employee Record, we would like them to match and currently they do not.
Thanks
V
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)
Vince, it's easy to create a database in Microsoft access and copy from the certified to the Occupation Field. Let me know if you need help.
[email protected]. I have some beginning ODBC class material I can send you as well.
Jenny,
I can get connected through ODBC just fine, pull in the tables i need into a database, etc. At what point is the data written back to Sage, all the records? Only the ones that had changes? How will this effect users currently in the system?
Yes, I would appreciate any help, Thank you
Vince,
Is this a onetime thing or something you want to repeat?
Bill,
Might need to do it a few, hoping just once though...
V
*Community Hub is the new name for Sage City