[AccessD] Need help with a combobox issue

Arthur Fuller artful at rogers.com
Mon Mar 28 10:47:09 CST 2005


I agree with you on the usefulness of UNION queries, and just want to 
add one comment which really has little to do with this thread, but 
concerns maximizing the utility of UNION queries.

I commonly see in other people's code such column names as ServiceName, 
ProductName, etc. I never name columns in this way. Instead I call both 
columns Name, and distinguish them with the tableName prefix: 
Services.Name and Products.Name. That way UNIONs are effortless, while 
the tableName prefix sidesteps ambiguity.

My $.02. :)

Arthur.

DWUTKA at marlow.com wrote:

>Glad to help.  Gotta love those UNION querries, they make life soooo much
>easier!
>
>Drew
>
>  
>



More information about the AccessD mailing list