Group update via a subform

[Rob W]

Hi all,
Steve M just helped me solve a foreign key issue, thanks steve. But now i'm
hoping i can do a group update.

Basically i have an asset register, with a subform that lists all
maintenance completed on each asset. There are 900 items in the register and
all are maintained at least twice a year, but in upto 4 groups. The easy fix
would be break up the db into 4 groups but..... The maintenance isnt on the
same assets at the same time. EG 1st maint is units 1 to 300, 2nd maint is
301 to 600. Next time the maint might be 150 to 450 then 1 to 149 & 451 to
600. or units not needing maint are ignored.

Here's the question, i have a group section in my main form, if i filter out
all but one group can i mass update the subform for all records even though
my subform has a foreign key connected to its record?

 

[John W. Vinson]

Hi all,
Steve M just helped me solve a foreign key issue, thanks steve. But now i'm
hoping i can do a group update.

Basically i have an asset register, with a subform that lists all
maintenance completed on each asset. There are 900 items in the register and
all are maintained at least twice a year, but in upto 4 groups. The easy fix
would be break up the db into 4 groups but..... The maintenance isnt on the
same assets at the same time. EG 1st maint is units 1 to 300, 2nd maint is
301 to 600. Next time the maint might be 150 to 450 then 1 to 149 & 451 to
600. or units not needing maint are ignored.

Here's the question, i have a group section in my main form, if i filter out
all but one group can i mass update the subform for all records even though
my subform has a foreign key connected to its record?

Well, you're crossing terms here.

The data is NOT in your form. The subform does NOT have a foreign key. The
maintenance is not being done on your form!

Data exists in your tables, and only in your tables. If you want to do a batch
edit, it's not necessary to use a form *at all* (though it may be handy to use
one for criteria); instead you would run an update query to update the data in
the Table.

If your table of assets contains a field indicating which group each asset
belongs to, you could use that as a criterion in an update query. Perhaps you
could post a description of the atable and indicate what needs updating to
what.

John W. Vinson [MVP]