External linking to multiple tables

[mike@rfsl]

I have an sql database I would like to link to from actinic. However the data I need is in several different tables.

Unfortunately the actinic linking tool only allows me to select a single table to link to. Does anyone know if there is a good way to get multiple tables imported into actinic?

One way I thought of was to create a 'View' for all the data I want and then have actinic link to this, however Actinic doesn't seem to allow linking to Views either...

[James M SellerDeck]

Hi Mike

Actinic cannot link to multiple tables, the best thing to do would be to create a query pulling all the relevent data from the different tables, and create a make table query that creates one table with all the data in that you can simply link to.

Hope that helps