populating a drop down menu from a concatenation string from 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 apology - did not mean to overstep my bounds - I thought I would get a
couple of different ways to complete a task
 
If you feel you need to post to more than one group (HINT: it's seldom
necessary), the recommended approach is to cross-post (send the one message
to all groups at once), rather than multi-post (send individual messages to
each group). In this way, all responses to your post will be available
together, regardless of what group the responder was in, and the rest of us
won't have to read your post multiple times. (It also uses fewer server
resources)

I see you're using Outlook Express. Click the "Newsgroups:" label to the
left of the box containing the name of the current newsgroup. That will open
a dialog that will let you add additional newsgroups to your post.

Note that it's generally consider to be A Bad Thing to cross-post to more
than about 2 or 3 newsgroups. (In fact, at
http://www.microsoft.com/presspass/features/2001/Mar01/Mar27pmvp.asp
Microsoft suggests that "One group will suffice")
 
Back
Top