How do I link the various export files from Actinic???

[Donna Kempster]

Hi I may be being very stupid but I have exported all my orders and got the respective files from actinic but when I look at them I cannot see any fields which I can use to link the orderlines file with the people file. I'd like to do this so I can produce a pack list external of actinic and also load into a database package??? Please help as at the moment I am having to re-key all my data at the moment which is a nightmare.....

[skinnybloke]

Hi - I think I have used this in the past to link the order to the person

INNER JOIN Order ON Person.ContactID = Order.InvoiceContactID

and this to join orders to order details

INNER JOIN OrderDetail ON Order.[Order Sequence Number] = OrderDetail.OrderSequenceNumber

[Jan]

You would link the order sequence number from the order file to the order sequence number in the order details file.

An easier way to export orders from Actinic is to use my One Stop Order Processing program, you can build the format you need up interactively and then export your orders. You can find more details and a free trial at this URL :

http://www.actinicplugins.co.uk/acat...rocessing.html

You need the advanced module to export.

Regards,