| Transaction Pattern Advice [message #1674] | 
			Thu, 18 September 2008 11:08   | 
		 
		
			
				
				
				
					
						  
						gpatti
						 Messages: 287 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?
		
		
		
 |  
	| 
		
	 | 
 
 
 |