Our issue is the database has been live for about a year. Its only added to occasionally, it only has 2 tables, one called ClinicCode and the other DrCode. I wanted to set this up to pass to the system administrator to add the codes rather than her contacting me.
The codes added are like CS CS4RH
Using a copy of the database we have changed the data types and each time we get an error.
The only time I can seem to get it to work is changing = to like. Includes doesn't work.
I thought using DataAssist would be easy but I'm tearing my hair out with this.