updating multiple tables on a form

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

CSWILKI - 28 Oct 2005 22:37 GMT

I am designing MDB where I update multiple tables from one form. Is there a
template for this? I keep getting too many fields and can't create the form.
Basically I have one unique key that each of the table has (normalized mdb).
Each section(sub form?) contains common information. I want to be able to
enter the new record and update the multiple tables that store the
information, then edit/change/update the information over time. Can I do
this one one form using a tab approach? Each tab represents a subform that
is associated to one of the tables.

Reply to this Message

Rob Oldfield - 29 Oct 2005 12:58 GMT

Sounds like it should work. If you're getting too many controls for the
form to be usable then I'd think about just displaying the key ones on the
main subform(s), with the others available via a linked form. (e.g. if you
have a personal details subform, then just display name, phone, address
immediately, with a button to pop up another form that allows the favourite
colour, hat size, name of dog etc fields to be accessed.

> I am designing MDB where I update multiple tables from one form. Is there a
> template for this? I keep getting too many fields and can't create the form.
[quoted text clipped - 4 lines]
> this one one form using a tab approach? Each tab represents a subform that
> is associated to one of the tables.

Reply to this Message