[AccessD] Dynamic SQL statement

Susan Harkins ssharkins at gmail.com
Mon Dec 7 19:15:49 CST 2015


I've just realized something similar. We have individual ids -- names and
tag numbers. An animal needs one or the other. I started with two fields and
I'm using UNION as needed. 

I should've used one field and added a field to describe it as name, tag
number, and whatever they decide to add later. :( 

Susan H. 

We all get blindspots. I've just come across one.  

For years, we've been storing essentially identical data in two sets of
columns depending on what Province the primary record belongs to.  (Don't
ask - I didn't design that, it was someone else's add on)

That has required different data screens and  variations on 3/4 of the CRUD
procedures on the primary records.

Just realised that I can combine these data points and simply everything
considerably.  Just need to change the data labels on the front end
depending on Province, but use the same procedures for all records.

Doh! again.




More information about the AccessD mailing list