i am currently studying a-level it and need to do a query that will enable me to input the user id into the sale screen and then this will bring up the name that is stored in a seperate field. all of my teachers are crap and i need to do this. pleae Help!

In seperate tables? If so, you'll want to use an INNER JOIN.

http://www.access-programmers.co.uk/forums/images/top_search.gif (http://www.access-programmers.co.uk/forums/search.php?s=)