Design ?

  • Thread starter Thread starter wallymeister
  • Start date Start date
W

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
 
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
Click to expand...

run an append query in the after update of the main form that runs a
query based on a cartesian product.
 
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
 
Back
Top