Add data to table

[brbarto]

When I enter data in a form, I would like to add some of the info in a second table. What is the best way to do this (or the easiest)?

Thanks

 

[tomschafer]

Create a relationship between the tables, and enforce referential integrity.

 

[brbarto]

But what if they have a one-to-one relationship?

Thanks

 

[tomschafer]

I'm not too hip when it comes to relationships so I don't know it it'll be able to be done then.
I would try to use an update query.
I know it can be done with VBA. Let me know if you need help with it.
Sorry if I sound a little confused but, I don't design a whole lot of de-normalized db's.

 

[brbarto]

Any help you can give me would be appreciated. I am very new to Access. How hard would it be to use VBA?

Thanks

 

[tomschafer]

To learn more about Access and SQL I would do it using a query. If you really want to I can show you how to do it with VBA. If you e-mail me your DB I can add both procedures into it send it back to you and answer any of your questions. My e-mail is twschafer@west.com