A
AccessAddict
I have a form setup that has a button which opens a query on the many side of
the logic by grouping records from the single side according to a field on
the one-side.
This query includes the one-side table and the many-side table.
The user requests that when selecting this group of records (setup with a
button to bring in this query) that it updates the whole many-side group with
information that they only type in once. The many-side “key†is a
combination of the item # and the Start date (various monthly dates that
would be repeated for each record on the one-side -- in duplicate) on the
many side.
EXAMPLE:
ONE-SIDE
Item # (once) …..with many other fields to this record in this table but
not the fields below on the MANY-SIDE
100507
101040
189440
189074
….
Etc.
MANY-SIDE
Item # Start End Amt
101040 1/2/05 1/29/05 50
101040 1/30/05 2/26/05 50
101040 2/27/05 4/2/05 40
101040 4/3/05 4/30/05 35
101040 5/1/05 6/4/05 40
101040 6/5/05 7/2/05 40
101040 7/3/05 7/30/05 40
101040 7/31/05 9/3/05 50
101040 9/4/05 10/1/05 50
101040 10/2/05 10/29/05 35
101040 10/30/05 11/26/05 40
101040 11/27/05 12/31/05 40
All of this information needs to update to all of the item #’s above (or
more) by only entering these twelve lines – once.
What would be the best way to update the many side as above for several
other Item #’s with exactly the same structure but only entering this
information once as above, yet updating the whole group (which is already
setup as a group and selected with a combo box).
At this time, the combo box brings up this group of data for EACH item # (as
a query) and the user has to enter 12 lines for as many items numbers as
their is in the group. I’m sure the answer is an update query …but am lost
in how to do that easily from one button and still let the user change the
information from group to group….as sometimes they have to eliminate some
items from the group.
Any suggestions are welcome.
Thanks.
the logic by grouping records from the single side according to a field on
the one-side.
This query includes the one-side table and the many-side table.
The user requests that when selecting this group of records (setup with a
button to bring in this query) that it updates the whole many-side group with
information that they only type in once. The many-side “key†is a
combination of the item # and the Start date (various monthly dates that
would be repeated for each record on the one-side -- in duplicate) on the
many side.
EXAMPLE:
ONE-SIDE
Item # (once) …..with many other fields to this record in this table but
not the fields below on the MANY-SIDE
100507
101040
189440
189074
….
Etc.
MANY-SIDE
Item # Start End Amt
101040 1/2/05 1/29/05 50
101040 1/30/05 2/26/05 50
101040 2/27/05 4/2/05 40
101040 4/3/05 4/30/05 35
101040 5/1/05 6/4/05 40
101040 6/5/05 7/2/05 40
101040 7/3/05 7/30/05 40
101040 7/31/05 9/3/05 50
101040 9/4/05 10/1/05 50
101040 10/2/05 10/29/05 35
101040 10/30/05 11/26/05 40
101040 11/27/05 12/31/05 40
All of this information needs to update to all of the item #’s above (or
more) by only entering these twelve lines – once.
What would be the best way to update the many side as above for several
other Item #’s with exactly the same structure but only entering this
information once as above, yet updating the whole group (which is already
setup as a group and selected with a combo box).
At this time, the combo box brings up this group of data for EACH item # (as
a query) and the user has to enter 12 lines for as many items numbers as
their is in the group. I’m sure the answer is an update query …but am lost
in how to do that easily from one button and still let the user change the
information from group to group….as sometimes they have to eliminate some
items from the group.
Any suggestions are welcome.
Thanks.