I have a master table with all of the vendor numbers and their names. I also have an orders table. To add a record to the order table you need to enter the vendor number. However, the users want to be able to enter the vendor number on the add page and then have it display the associated vendor name from the other table before they save the record. The old system they use lets them enter the vendor number and hit enter and then it displays the vendor name before they enter the rest of the information to add to the orders table. I'm not sure how I could do this? There would need to be another button or maybe a popup box before it saves like the delete popup box but it could display the vendor name. I am sure I am missing the obvious but..... Do you have any ideas? Thanks.