Concatenate & forms

  • Thread starter Thread starter northstar
  • Start date Start date
N

northstar

I have created a query containing the concatenation of customer ID, LName,
and FName. Syntax is not a problem. Can I use this concatenation as a look-up
in forms wherever the data is needed? Many of our forms have three data entry
fields for this same data. I want to consolidate the three into a single
look-up for multiple forms. Thanks for replies, even if you tell me I can't.
 
Yes it will work, but I am not sure why you would need to have the
three fields concatenated. A lookup or for that matter a combo box
with the ID as control or a linked table linked by ID would seem to be
sufficient unless you have multiple lastnames etc for a single
customer ID.

Ron
 
Back
Top