1 Reply Latest reply on Jun 28, 2014 12:03 AM by TKnTexas

    Merging two or more database fields into one layout

    TreverRevert

      Title

      Merging two or more database fields into one layout

      Post

           Hello,

             Currently I have an external ODBC SQL database called "web_artists" along side another internal table called "artists".  These both have "first_name", "last_name", and "middle_name" fields. I want to have these combine the records of artists into one layout. I don't want to just import the data to the internal table though. I want to be able to add a new artist to the SQL database and have the Artist layout automatically show this new artist. How is this done?