I have 2 tables that I am trying to relate with each other through my employee position numbers
I have created a position# field in both tables and linked them. My issue is that the position numbers are 6 digits long and i am using the link to fill in some form letters to get magers info.
when I enter an employee position number (example 901225)
i need the related table to show any position number between 901001 and 901999 = John Smith as the manager. That way on my form letter John Smith's info that I have on his record will fill in.
Please help if you can understand