Thanks for the help june. I decided to scrap what I had and start over, this time instead of creating multiple tables for each field I simple created the lookup fields within my main table. Then I plugged your VBA coding in and it works just the way I need it to. Much easier this way. And to answer your question I do believe I was saving keys into injbinmanagement before because when I was trying to sort some of the fields I needed to use their key#'s rather than the actual data in that field if that makes sense. Anyways thanks for the help if I run into more trouble I'll be back, you've been a big help.




Quote Originally Posted by June7 View Post
But are you saving Material and Resource keys into injbinmanagement?

If you want to provide db for analysis, follow instructions at bottom of my post.