Converting Access to SQL help (it nearly worked)

Hello fellow carters,

I have been given the wonderous task of trying to convert our access driven store over to sql, after a bit of reading and such I managed to convert all the data over correctly as far as I could see and when I hooked it up to our store everything looked to be running as it should.

However the BTO section seems a bit broke, you can browse and select a BTO item but trying to add to cart or customise it causes it to generate an error message, looking at the error log I am getting this message.

Invalid column name 'pcProd_showBTOCMMsg'.<p>query=SELECT quantityFrom,quantityUntil,discountperUnit,percentage,discountperWUnit,baseproductonly FROM discountsPerQuantity WHERE IDProduct=3355</p>

The BTO items do have a price next to them so I guess they are semi working in some form. The only thing I can see that is different between the access and sql version are the relationships are missing, is this the most likely cause or am I missing something else?

As always any advice greatfully received :)

Hi Mark,

Thanks for the reply, I shall drop you a mail.

Andy,