Mocha Float
New member
- Local time
- Today, 13:52
- Joined
- Feb 15, 2013
- Messages
- 9
Hey guys,
Just a heads up, I'm using Access 2010 Web.
So for a previous task, for certain records with specified criteria, I would need to create an associated record that has the same criteria, but negative values. To do this I created a Linked ID column and assigned the ID of the original record to the Linked ID field of the new one. This way I could modify the values by searching for the Linked ID whenever the original record is changed, all done in the After Update macro.
My next task is slightly more complicated. Given specified criteria for a record, I would need to sum the values of multiple records then take the difference from a different sum of multiple other records. Then I would create a new record to hold this new value, and those same criteria. The problem with the previous solution here is that there are multiple records while I can only hold one ID. I've also thought about using the solution in reverse, by putting the ID of the newly created record into the Linked ID of the original ones. However, this would mean the Linked ID field for the original is Null when I'm creating the new one, and the calculations are therefore independent of the Linked ID value. Because of this, a change to the newly created record (which does NOT have a Linked ID) would also trigger to create a NEW record based on the former.
I've thought of creating a text field and simply concatenating the ID values and then decoding it to find which records to reference, but I feel as though that is too much unnecessary work for what I'm trying to accomplish. I'm also not sure if I conveyed my problem correctly so feel free to ask for clarification. Any ideas?
Thanks in advance!
Just a heads up, I'm using Access 2010 Web.
So for a previous task, for certain records with specified criteria, I would need to create an associated record that has the same criteria, but negative values. To do this I created a Linked ID column and assigned the ID of the original record to the Linked ID field of the new one. This way I could modify the values by searching for the Linked ID whenever the original record is changed, all done in the After Update macro.
My next task is slightly more complicated. Given specified criteria for a record, I would need to sum the values of multiple records then take the difference from a different sum of multiple other records. Then I would create a new record to hold this new value, and those same criteria. The problem with the previous solution here is that there are multiple records while I can only hold one ID. I've also thought about using the solution in reverse, by putting the ID of the newly created record into the Linked ID of the original ones. However, this would mean the Linked ID field for the original is Null when I'm creating the new one, and the calculations are therefore independent of the Linked ID value. Because of this, a change to the newly created record (which does NOT have a Linked ID) would also trigger to create a NEW record based on the former.
I've thought of creating a text field and simply concatenating the ID values and then decoding it to find which records to reference, but I feel as though that is too much unnecessary work for what I'm trying to accomplish. I'm also not sure if I conveyed my problem correctly so feel free to ask for clarification. Any ideas?
Thanks in advance!
