There is a field mismatch in the union query. Field SalesName is not compatible with field Description.

(0) Share

Report

Posted on by Laraib

131

I am creating relation between salestable and PriceDiscAdmTable. In this context I have added new column in salestable named as JOURNALNUM and I also created relation in salestable but when I am synchronizing table it is giving following error

I have the same question (0)

All responses (1)

Answers (1)

Verified answer

Gunjan Bhattachayya 35,423 on at

Like (1)

Report

Hi Syed,

I don't think the error is being thrown due to the new relation you created. If you remove the relation and synchronize the database, does the error go away? If not, I would suggest you do a full compile of the application from command line and check if you can find the query throwing the error.

Was this reply helpful? Yes No