So i did learn few things about SQL, SSMS and learning new stuff every day. Got little problem which I don't understand - or i am missing something.
I am using MS POS 2009 Database - stored on SQL Server 2008. Installed SSMS and got access to MSPOS database.
What I want to do:
Change default supplier of item from supplierid 1 to 2
itemlookupcode, description, supplierid
Pen-123, Pen black, 1
How I am doing it:
set supplierid=2 (tried '2')
where Item lookupcode='Pen-123'
when I query said item, supplier ID is updated to '2' all good so far
When I go to MS POS 2009 and search for item, then open it to check supplier (if changed) POS crashes.
Working on test system, Installed POS with SQL Server -> restored database in POS -> installed SSMS and accessing restored database.
Tried to check database diagrams, but empty inside (can't see relations)
Anyone able to help with this, any tips appreciated. Not sure what I do wrong