As I said..."I may be overlooking the obvious." :P THANKS Stephen & Norm
-----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Heider, Stephen Sent: Tuesday, June 05, 2007 8:38 AM To: arslist@ARSLIST.ORG Subject: Re: Menu Question This is a multi-part message in MIME format. ------_=_NextPart_001_01C7A776.B0D1A3D8 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable Brian, =20 You could use a SQL menu, such as this example with the User form: SELECT Login_Name FROM User_x UNION SELECT Full_Name FROM User_x =20 Stephen=20 =20 ________________________________ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Brian Gillock Sent: Tuesday, June 05, 2007 9:32 AM To: arslist@ARSLIST.ORG Subject: Menu Question **=20 ARS Comrades, I may be overlooking the obvious here, but... I have a form that stores patient information. In that I have primary and secondary physicians. I realize now that storing those in the same form wasn't exactly the best way to go about it, but it's getting late in the game and I'm hoping not to have to make a change. Is there a way to pull both physicians into a menu? I want to be able to select between the two physicians in another form. =20 =20 Thanks! Brian __20060125_______________________This posting was submitted with HTML in it___ ____________________________________________________________________________ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are" ------_=_NextPart_001_01C7A776.B0D1A3D8 Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable ** <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <HTML xmlns:v =3D "urn:schemas-microsoft-com:vml" xmlns:o =3D=20 "urn:schemas-microsoft-com:office:office" xmlns:w =3D=20 "urn:schemas-microsoft-com:office:word" xmlns:m =3D=20 "http://schemas.microsoft.com/office/2004/12/omml";><HEAD> <META http-equiv=3DContent-Type content=3D"text/html; = charset=3Dus-ascii"> <META content=3D"MSHTML 6.00.2900.3086" name=3DGENERATOR></HEAD> <BODY lang=3DEN-US vLink=3Dpurple link=3Dblue> <DIV dir=3Dltr align=3Dleft><SPAN class=3D401443613-05062007><FONT = face=3DArial=20 color=3D#0000ff>Brian,</FONT></SPAN></DIV> <DIV dir=3Dltr align=3Dleft><SPAN class=3D401443613-05062007><FONT = face=3DArial=20 color=3D#0000ff></FONT></SPAN> </DIV> <DIV dir=3Dltr align=3Dleft><SPAN class=3D401443613-05062007><FONT = face=3DArial=20 color=3D#0000ff>You could use a SQL menu, such as this example with the = User=20 form:</FONT></SPAN></DIV> <DIV dir=3Dltr align=3Dleft><SPAN class=3D401443613-05062007><FONT = color=3D#0000ff=20 size=3D2> <P>SELECT</FONT><FONT size=3D2> Login_Name </FONT><FONT color=3D#0000ff=20 size=3D2>FROM</FONT><FONT size=3D2> User_x</P></FONT><FONT = color=3D#808080 size=3D2> <P>UNION</P></FONT><FONT color=3D#0000ff size=3D2> <P>SELECT</FONT><FONT size=3D2> Full_Name </FONT><FONT color=3D#0000ff=20 size=3D2>FROM</FONT><FONT size=3D2> User_x</P></FONT></SPAN></DIV> <DIV> </DIV> <DIV><SPAN class=3D401443613-05062007><FONT face=3DArial = color=3D#0000ff>Stephen=20 </FONT></SPAN></DIV> <DIV><FONT size=3D2></FONT> </DIV> <DIV><BR></DIV> <DIV class=3DOutlookMessageHeader lang=3Den-us dir=3Dltr align=3Dleft> <HR tabIndex=3D-1> <FONT face=3DTahoma size=3D2><B>From:</B> Action Request System = discussion=20 list(ARSList) [mailto:[EMAIL PROTECTED] <B>On Behalf Of </B>Brian=20 Gillock<BR><B>Sent:</B> Tuesday, June 05, 2007 9:32 AM<BR><B>To:</B>=20 arslist@ARSLIST.ORG<BR><B>Subject:</B> Menu = Question<BR></FONT><BR></DIV> <DIV></DIV>**=20 <META content=3D"Microsoft Word 12 (filtered medium)" name=3DGenerator> <STYLE>@font-face { font-family: Cambria Math; } @font-face { font-family: Calibri; } @page Section1 {size: 8.5in 11.0in; margin: 1.0in 1.0in 1.0in 1.0in; } P.MsoNormal { FONT-SIZE: 11pt; MARGIN: 0in 0in 0pt; FONT-FAMILY: = "Calibri","sans-serif" } LI.MsoNormal { FONT-SIZE: 11pt; MARGIN: 0in 0in 0pt; FONT-FAMILY: = "Calibri","sans-serif" } DIV.MsoNormal { FONT-SIZE: 11pt; MARGIN: 0in 0in 0pt; FONT-FAMILY: = "Calibri","sans-serif" } A:link { COLOR: blue; TEXT-DECORATION: underline; mso-style-priority: 99 } SPAN.MsoHyperlink { COLOR: blue; TEXT-DECORATION: underline; mso-style-priority: 99 } A:visited { COLOR: purple; TEXT-DECORATION: underline; mso-style-priority: 99 } SPAN.MsoHyperlinkFollowed { COLOR: purple; TEXT-DECORATION: underline; mso-style-priority: 99 } SPAN.EmailStyle17 { COLOR: windowtext; FONT-FAMILY: "Calibri","sans-serif"; mso-style-type: = personal-compose } .MsoChpDefault { mso-style-type: export-only } DIV.Section1 { page: Section1 } </STYLE> <!--[if gte mso 9]><xml> <o:shapedefaults v:ext=3D"edit" spidmax=3D"1026" /> </xml><![endif]--><!--[if gte mso 9]><xml> <o:shapelayout v:ext=3D"edit"> <o:idmap v:ext=3D"edit" data=3D"1" /> </o:shapelayout></xml><![endif]--> <DIV class=3DSection1> <P class=3DMsoNormal>ARS Comrades,<o:p></o:p></P> <P class=3DMsoNormal style=3D"TEXT-INDENT: 0.5in">I may be overlooking = the obvious=20 here, but… I have a form that stores patient = information. In that I=20 have primary and secondary physicians. I realize now that storing = those in=20 the same form wasn’t exactly the best way to go about it, but = it’s getting late=20 in the game and I’m hoping not to have to make a change. Is = there a way to=20 pull both physicians into a menu? I want to be able to select = between the=20 two physicians in another form.<o:p></o:p></P> <P class=3DMsoNormal><o:p> </o:p></P> <P class=3DMsoNormal><o:p> </o:p></P> <P class=3DMsoNormal>Thanks!<o:p></o:p></P> <P=20 class=3DMsoNormal>Brian<o:p></o:p></P></DIV>__20060125___________________= ____This=20 posting was submitted with HTML in it___</BODY></HTML> __20060125_______________________This posting was submitted with HTML in it___ ------_=_NextPart_001_01C7A776.B0D1A3D8-- -- No virus found in this incoming message. Checked by AVG Free Edition. Version: 7.5.472 / Virus Database: 269.8.9/832 - Release Date: 6/4/2007 6:43 PM _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
