populating a drop down menu from a concatenation string in an expression

  • Thread starter Thread starter King Kaos
  • Start date Start date
K

King Kaos

All right, I have a table that has client information in it including
schooladdress, homeaddress, and physiciansaddress. I have a different table
that is called a SALTable where I have to fields - TravelFrom and TravelTo.
In the form for SALTable I want to make the TravelFrom and TravelTo drop
down menus and have it add the schooladdress, homeaddress, and
physicianaddress from the ClientTable. Can I do this? As well as add other
common addresses to the drop down menu like courthouseaddress, DHHRaddress,
othercommunityaddresses etc.



Should I start by making a query that has like ClientName and then the
schooladdress, homeaddress, and physiciansaddress - then build an equation
using a string concatenation that creates a field in the query called
AllAddresses - schooladdress, homeaddress, physiciansaddress,
courthouseaddress, DHHRaddress, othercommunityaddresses.



I can do this - do I need to some kind of run query statement in my form to
filter one client at a time? Or something? And the have the TravelFrom and
TravelTo fields Select the AllAddersses Field - or am I making this just way
to hard. Any help would be appreceiated, I'm still pretty new at this -
thanks

Keith
 
Please do not post duplicate messages to multiple groups. You don't need
more than one person answering your question.

Rick B
 
My apologies - I was not sure the first post went through and then thought
it would be more appropiate in the other group
 
Back
Top