Transaction Pattern Advice [message #1674] |
Thu, 18 September 2008 11:08 |
gpatti
Messages: 283 Registered: August 2008
|
Senior Member |
|
|
Would appreciate some guidance on the most suitable transaction pattern for some functionality:
I have a one -> many table relationship where the many table is controlled by start and end dates (so only one effective row per parent row at any given time).
I want to build a transaction that displays all the rows similar to a LINK1 transaction (where there would be exactly one line per parent row) but allows me to update a row on the many table (or even insert if one doesn't exist).
Can a LINK1 transaction be extended in this way?
|
|
|