Your inquiry is probably too general to get much response here. What do you
specifically mean by "interface"? What program is generating the invoices
now? Can that program export data files? Do you need a real-time system or
will batch updates once or a few times a day suffice?
Personally, I would either add the invoicing functionality to the Inventory
control database, or add the inventory control functionality to the
invoicing database, given that either or both are currently in Access.
Another possibility is linking tables from one application to the other, and
adding code as appropriate.
UpRider
