Design ?

[wallymeister]

My question is this.....

Can I create a form that when a new record is added, a subform on that form
will automatically add all items that are in another table. e.g.

I have a [models] Table and a [Items to check] Table. When I go to new
record on a form based on [models] Table, I want a subform based on [Items
to check] Table to automatically to fill in with additional fields of course
that have to be updated by the user. Presently, they have to either copy and
paste these items (which are always the same) to the new record or enter them
one at a time from a dropdown box.


Any help would be greatly appreciated.
Thanks,
wally

 

[Piet Linden]

My question is this.....

Can I create a form that when a new record is added, a subform on that form
will automatically add all items that are in another table.  e.g.

I have a [models] Table and a [Items to check] Table.  When I go to new
record on a form based on [models] Table, I want a subform based on  [Items
to check] Table to automatically to fill in with additional fields of course
that have to be updated by the user.  Presently, they have to either copy and
paste these items (which are always the same) to the new record or enter them
one at a time from a dropdown box.

Any help would be greatly appreciated.
Thanks,
wally

run an append query in the after update of the main form that runs a
query based on a cartesian product.

 

[wallymeister]

Piet,
What do you mean by cartesian product? Does this just mean as long as it
follows logical rules?

I have never done an append query but it seems that would certainly do the
trick. I'll give a try.
Thanks