AnsweredAssumed Answered

FInd help - should be simple?

Question asked by AmberJeffery on Mar 20, 2016
Latest reply on Mar 21, 2016 by AmberJeffery

Hello all,

 

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

Amber

Outcomes