I have been trying to get this to work all weekend and have had no luck, I feel like I have confused myself so much...
When I created my database I set it up wrong, I know this and am currently working on a new one, however I do have people using my "bad" one until the other is finished.
I need a simple search solution. I have one table ( I know I should use many with relationships..) on this table are two of the fields are "applicant1surname" and "applicant2surname".
Often applicant 1 and applicant 2 have different surnames however are part of the same application.
SO can I create a field to enter a name in to then when a "search" button is pressed it looks at both the surname fields to find a match and shows all records that have the name in either field?
or do I "find" the name in one and if it no result it checks the other?
I hope I have not confused you (I am) but how do I do this it seems so simple but I cant get it..
All help is appreciated however telling me it is a structure problem is not helpful I just need to know if It is possible in the structure I have.
Many many thanks