Creating Table from two fields in Master Table
I have a Master table with 600+ records. Each record has two fields FIELD_A and FIELD_B. I am looking for a way to use the data from the Master Table to create a new table, layout, or report combining the data into a single list as follows:
Record 1 ---- FIELD_A
Record 1 ---- FIELD_B
Record 2 ---- FIELD_A
Record 2 ---- FIELD_B
Record 3 ---- FIELD_A
Record 3 ---- FIELD_B, etc...
I've tried everything I know, but can't figure this one out. PLEASE HELP!!