Hi,
I'm trying to setup a table that uses the data from other tables. That way when I make a form for it I can enter the ID number for the record I'm looking for and all the information with automatically show up.

jlabre01

Are your tables related? You need to search here on normalization and relationships if they aren't. If they are I think you'd be better off creating a query that takes the data from your tables and using that as the underlying recordset for your form rather than making a new table. You could then use a list or combo box to find the record you want to update.