Well, I have opened my accounts package which has a table called items. This holds all the fields like product name, price, cost, mark-up etc. In MySql database there is a table called products. In this there are fields called product code, price, cost etc. The fields dont line up as the MySql database has more fields than the access one and the names are different. I cannot re-name any field as this would cause the program to stop working.
...

I run a website selling cartridges. My stock on the website is in a MySql database. My accounts package and invoicing software runs on an Access database. In my website databse there is a table called products, on my accounts Access database there is a table called items. I am trying to link certain fields in MySql database with certain fields in Access database. The reason for this is so when I update the price in the accounts database (access)...