I have a problem tracking application in Access 97 that the employee id field is going to a lookup table and is filling in that field. However I do have other corresponding fields in both tables like name ext dept etc that I would also like to be autofilled from that look up table after you've selected the correct employee id. How can I do this. I've done alot of database work in Paradox and you just say fill all corresponding fields but it's not that easy in Access. Please Help!!!