3 Replies Latest reply on Dec 3, 2012 4:40 PM by philmodjunk

    Creating Table from two fields in Master Table

    MLind

      Title

      Creating Table from two fields in Master Table

      Post

           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!!