Working against SQL and Visual Basic

[Ingar]

Hi,

I need a bit of advice on what to do.

What I need:

I have a CRM software with all my customers. ( And I can't swap this with FMPro ). This is SQL based.

I have an order DB and a customer DB in FMPro which I need to link to my CRM system. The Customer DB has to be up to date against the SQL DB.

Then I would like to perform a search in FMPro to look up a customer.

If the customer doesn't exist I have to use Visual Basic code to add a customer to my CRM system.

The reason why I have to use Visual Basic is that my CRM uses the COM/DCOM technology from MS and I have to program against this. ( Because of rules and default values that is defined in the components ).

Is it possible to run Visual Basic code from inside FMPro and how should i make FMPro and SQL DB to be synchronized ?

I hope someone understands my needs, english is not my main language.

Ingar

[Anatoli]

Try http://www.clickware.com/products_plugin.htm

and http://www.fmcdn.com/index.html

HTH