Hi
I have one field in my table where i look up an ID value, however once this ID value is looked up i want to populate the next field with the weight the ID correseponds to. how can I do this?
Hope that makes sense
Cheers Dan

Download this Sample (http://www.access-programmers.co.uk/forums/showthread.php?p=293920#post293920) database. It shows the three most common ways to do this.