AnsweredAssumed Answered

relating tables?

Question asked by on Apr 14, 2009
Latest reply on Apr 15, 2009 by philmodjunk


relating tables?


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