Combining records into one field

[jgarnick]

I have two tables with a one-to-many relationship related by an id field.&nbsp;&nbsp;I would like to have a field in the &quot;one&quot; table that would summarize a particular field in the &quot;many&quot; table for each id.<br><br>For example:<br><br>Table &quot;one&quot;<br><br>id 10000 <br><br>Table &quot;many&quot;<br><br>id 10000&nbsp;&nbsp;&nbsp;&nbsp;year 1990<br>id 10000&nbsp;&nbsp;&nbsp;&nbsp;year 1993<br>id 10000&nbsp;&nbsp;&nbsp;&nbsp;year 1997<br><br>I would like a field in table &quot;one&quot; to display 1990,1993,1997 in it.&nbsp;&nbsp;I need to be able to do this for the current records in the table AND also have the field in the &quot;one&quot; table updated each time another record is added to table &quot;many&quot;.<br><br>Hope this makes sense to someone out there!&nbsp;&nbsp;Thanks! <p>jgarnick<br><a href=mailto:jgarnick@aol.com>jgarnick@aol.com</a><br><a href= > </a><br>

 

[advpay]

It looks like its stored correctly to me...do you need it summarized for a form or report field?

 

[jgarnick]

I was thinking it could be stored in a field in a table that could be used on forms or reports.&nbsp;&nbsp;My particular need at the moment is to display the data on a form.<br><br>Any ideas? <p>jgarnick<br><a href=mailto:jgarnick@aol.com>jgarnick@aol.com</a><br><a href= > </a><br>

 

[xtreme1]

I sent you an example database doing what I think you'd like to accomplish.&nbsp;&nbsp;I hope it helps. =] <p>xtreme1<br><a href=mailto:rbio@excite.com>rbio@excite.com</a><br><a href= > </a><br>