Is there a way in an access 2003 table to have a ID field that if matched will autofill specified other fields? For an example please see the attachment, thank you in advance.

- table id's (primary keys) must be unique; if it's a foreign key you don't need the other info, it already exists in another table;
- if the id is autonumber then you can't enter the id anyway.

Plus, you don't store anything but the foreign key for the record (Normalized) so you don't need to autofill anything except the foreign key and that can happen if you use a mainform/subform with the appropriate Master/Child Links set.

I agree with the other posters. You may want to autofill a form so that all the data is visible to the user, but you don't duplicate the data. You need to base your form on a query that joins the two tables together.