Adding records to multiple tables

[Bakunin]

Hi,
I have two tables on a form, and when I add a record to one table I need it to automatically add the record to the other table.

Can anyone let me know if this is possible?

Thanks

Bakunin.

 

[JerryDennison]

Clearly you need a better understanding of the Forms of Data Normalization. You should not be duplicating data between tables, nor should you be creating "empty" records.

I understand what you're tyring to do, but there really is a much better way to accomplish what you want without creating a database that will become impossible to manage. By creating two records in two tables at the same time from essentially the same data you'll make it extremely difficult to change or modify this data later. If a mistake is made it'll have to be corrected in two places instead of one.

 

[JoeMiller]

Could you be talking about a subform with linked records? If so you can use the wizard that ships with access to set up the link between your main form and your subform.