Are there "gaps" in the number of people if you sorted the income allowed table by number of people or do you have one record for each and every possible number of people possible?
Assuming one record for each possible number of people.
Assuming this relationship:
MaxIncome::PersonCount = ApplicationTable::PersonCount
Then this calculation defined in a calculation field in the ApplicationTable:
MaxIncome::Income < MonthlyIncome
Will return 1 (True ) if MonthlyIncome is less than or equal to the number you enter into the Income field in the Max Income table and 0 (False) if it is not. You can either use the Inspector's Data tab to format this field as a boolean to show "Yes" for True and "No" for false, or you can put this expression inside an If function like this:
If ( MaxIncome::Income < MonthlyIncome ; "Yes" ; "No" )
I actually figured it out a different way.. Thanks anyways phil. But your way will work as well.