AnsweredAssumed Answered

relating tables?

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

Title

relating tables?

Post

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

Outcomes