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?
Using TEXT just type:
Type it as if a label on the Layout.
I know this works for a FMP table, I think it should also work for the external table you have defined as such. I hope this helps.