I have a table from which I need to select up to 4 records (using 2 of the fields from each record) and append them into a single record within another table, NAME1, NAME2 etc. Any suggestions ?
Thanks
Jerry