Hi all, 

I'm populating a table from a lookup, which has 2 columns a position and a position ID. 

I am populating a dropdown for the user to select the position, but just wondering how I can populate the position ID automatically. Usually I can do a lookup to do a match on the position name , but a position might have the same name and cause issues, hence I'd like to populate the position ID by another method other than just matching the position name.

Any ideas on tackling this appreciated.