I want to be able to take multiple values from field SOMETHING from many records in my Child table and store in a single field SOMETHINGS in my Parent table.
For example in the Child I may have the following:
Record#1 - SOMETHING = A
Record#2 - SOMETHING = B
Record#4 - SOMETHING = C
Then in my Parent table my SOMETHINGS field would read A,B,C etc...
I know I can do this with lookup fields however my SOMETHING field could have over 500 different values in different records and so this would take a lot of lookup fields.
I am looking for an easier way to do this, maybe using Dan Diebolts Image Onload Technique?
Any help will be greatly appreciated.