combo box problems...

[GR]

Hi,

I have a linked table listing Sales managers. A second
table listing Drives managers.
I need a combox which can be populated by both tables. and
if the person the user is typing in is not in the list
give the chance to the user to type in the new name and
ask if this new name should be added to the sales or
drives table (so the name is kept in sales or drives
tables and de combo is refreshed with the new name) the
design of the tables can't change, i mean, i've been asked
not to create a new table having sales and drives persons,
i've been ask to concatenate if possible both tables in
the combo. also this combo should allow multiple
selections..
any suggestions?? =/

 

[Arvin Meyer]

This question has been answered in the m.p.access group
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access