Merging two or more database fields into one layout
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?