update multiple tables at once

[Erik]

I was just wondering if it were possible to update another table after
inserting a new record into another table.

What I have is a table that has a list of names and information. In another
table I have those same names but with much different information. If I add a
record to the first is it possible to have that same name added to the other
table? or should I just consolidate the two tables?

Also I have a subform in one of my forms that gets information from a query.
When I created the subform it allows me to use text boxes and such but when I
run the subform it just come up in Datasheet view. Is there a way to make it
come up in a form view?

Thanks,

 

[John Vinson]

I was just wondering if it were possible to update another table after
inserting a new record into another table.

What I have is a table that has a list of names and information. In another
table I have those same names but with much different information. If I add a
record to the first is it possible to have that same name added to the other
table? or should I just consolidate the two tables?

Storing the name in two tables is in fact a Very Bad Idea. Adding a
record with just the name (and without the information) is perhaps
even worse.

Either consolidate the tables; or if the information is really of a
different kind between the two tables, be sure that you have a unique
Primary Key in the first table, and have a matching foreign key in the
second table. You can use a Subform to link the two.

Also I have a subform in one of my forms that gets information from a query.
When I created the subform it allows me to use text boxes and such but when I
run the subform it just come up in Datasheet view. Is there a way to make it
come up in a form view?

Open the Form you're using in the subform control; view its Properties
in design view; change the Default View property from Datasheet to
either Single or (probably the best of both worlds) Continuous.

John W. Vinson[MVP]