External Database Links in Actinic Business

[Mark Warner]

Hi All - I hope this is the correct place to post this.
I have a client who will be shortly using actinic. He requires to use an external table (Access or Excel) to hold product records with just three or four fields (e.g. product ref, description, stock level)
His catalogue may have products in alot of sections and subsections. My question is:
(a) If a new product is added in some subsection in the catalogue - will this just appear as a record in the external table?
(b) What about the other way round - if a product (just prod ref, decription and stock) is added to the external table - does this appear in the catalogue an if so where?

[Jan]

(a) If a new product is added in some subsection in the catalogue - will this just appear as a record in the external table?
No, it will have to be added to the external table manually.

(b) What about the other way round - if a product (just prod ref, decription and stock) is added to the external table - does this appear in the catalogue an if so where?
It will appear, in a new section called unlinked external products at the bottom of the catalog tree, unless it has the same reference as one of the fields already linked in which case it will be linked automatically to that product (so long as you ticked the always link option on the linking dialog in Actinic when you set up the link).

Regards,