New to database work and FileMaker
Hi everyone, first, thanks in advance for any help or even just putting up with what's probably a silly question to most of you.
I'm trying to create a database that links information provided by schools with information provided by students.
I want to link the entries by matching a few fields (State, Grade, School, First Name, Last Name) however, the problem I'm running into is that the names provided by schools doesn't always match the way that students write in their names. For instance, schools might list the student name as John Smith Doe while the student writes his name in as either John Smith or John Doe.
I have two tables set up each fields of State, Grade, School, First Name, Last Name 1, Last Name 2
I'm wondering if there's a way to have FileMaker lookup/match the information if State, Grade, School, and First Name match and if either Last Name 1 matches Last Name 2, or if Last Name 1 matches last name 2
Any tips/help would be hugely appreciated!
- Jennifer (Research assistant turned new database manager)