Connect to VFP Application or convert VFP into PHP??

Hi There

We have a fairly sophisticated database that's written in VFP for MySQL.

I'm building some insert/update pages for our customers to be able to insert and update records in the database, this is where it get's a little tricky. There is a program that handles certain business rules, and alos look's after assigning certain key's in a certain manner, to maintain database integrity.

Now, I can insert certain fields into certain tables with no poblems...however one part of the program is looking at a table field, reading it for use in the record, then incrementing it - however it's not a plain old auto-number, the VFP program itself is incrementing it, as it is a combination of numeric & alpha values...

so, would it be best to find some way of being able to connect to this program?

or

have the program converted so that the same procedures run on the database at the time of record insertion??

Thanks

Pete

I have the VFP if anyone would like to see it...