Re: Log all data in fields from all records in Table A to a single new record in Table B
But the fields in the tables are not the same. He has 7 records in Table A, with 7 fields each, and he wants to take that data and create one snapshot record in Table B with all 49 fields represented separately.