beginner with tables

[jlabre01]

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

 

[BarryMK]

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.