Hi all,
I have a table, tblPerson and in that table i have the PersonID, FirstName, LastName, sFirstName, sLastName and some other stuff not related to my question at hand....
I am trying to create a form with a listbox and then a search filter to filter that list.
What I am wondering or asking is, is there anyway to pull the ID, First, sFirst, and Last name into the list box as two records? So I can search for a name wether it be the first name or sfirst name in the search filter.
First would be first name, sFirst would be spouce first name and last for both.... If spouce name was not null....
Id First Name Last Name
1 David Pierce
1 Jonna Pierce
2 Robert Howard
ad so on.
Basicall take the two names from one record and make them two records?
Any assistance would be just fantastic. Have been trying several qrys, list box and so forth but cannot seem to bring both names from a record and make two out of them
Thanks
Dave