Auto fill info from one table into another

[Christine Jackson]

Hi

is it possible to pull data from one table into another without having to select from a list.

I have 2 tables, one Car details, another Financial Information. I need to retain certain information in the Car details table, such as CO2 levels, list price etc, but I also need that information in the financail info table.

Is there any way I can link the 2 so that when i put the reg into the financail info table, it automatically pulls through the co2 level and list price?

I know i can do this if I use Forms, but I need to do this in table format, as i have calculated fields that need this information.

I know I can use the lookup Wizard to get values from another table, but it only gives you a drop down list of the information, allowing for incorrect info to be selected.

Any ideas anyone?

Thanks
Chris

 

[Trevor G]

Sorry you can't do that with a table, you could use an update query or as you have worked out a form. Also some VBA code for an SQL update can be used.