combo box combining 2 columns into 1

[jeremy0028]

I have the following table called people

PersonID(pk Autonumber)
LastName
FirstName
Mi
PrimaryInsurance(lookup)
SecondaryInsurance(Lookup)

I have a form called add charge and on that form i have a combo box billed to Which looks up people table personID, PrimaryInsurance,Secondary Insurance

Heres the problem i'm having with the bill to. the combo box is display the Person Primary and Secondary insurance as 2 columns Example Medicare Medical.

I want the combo box to look like this
Meidcare
Medical

In one column not to any ideas.

 

[BoxHead]

I think a union query might solve your problem.

Along the lines of

SELECT PersonID, FirstName & " " & Mi & ". " & LastName AS Expr1, PrimaryInsurance 
FROM People
UNION
SELECT PersonID, FirstName & " " & Mi & ". " & LastName AS Expr1, SecondaryInsurance 
FROM People
ORDER BY PersonID;

John




Life is short.
Build something.

 

[jeremy0028]

I tried what you specified but still dosnt work. Here is the code i have in the bill to combo box

SELECT [tblPeople].[PersonID], [tblPeople].[PrimaryInsurance], [tblPeople].[SecondaryInsurance] FROM [tblPeople];

 

[BoxHead]

Try

SELECT [tblPeople].[PersonID], [tblPeople].[PrimaryInsurance] FROM [tblPeople]
UNION
SELECT [tblPeople].[PersonID], [tblPeople].[SecondaryInsurance] FROM [tblPeople]
ORDER BY [tblPeople].[PersonID];

Life is short.
Build something.