Hi, This is a clear case of lack of data integrity , check synchronize the table and delete the incosistent data. reagrds, Kumar
G Radhakrishnan <[EMAIL PROTECTED]> wrote: Is it happening after compilation, synchornization and indexing ? --- Altamash <[EMAIL PROTECTED]> wrote: > Hello, > > I am facing this problem for the first time and > don't know wht went > wrong overnight. The forms were working fine till > yesterday night but > started giving the error when i tried to execute the > forms today. > > The error messages are listed below in the sequence > as shown in Axapta : > 1.Cannot select a record in ASSNCustomerMasterTable > (ASSNCustomerMasterTable). > > The SQL database has issued an error. > 2.SQL error description: [Microsoft][ODBC SQL Server > Driver][SQL Server] > Invalid object name 'ASSNCUSTOMERMASTERTABLE'. > > 3.A.ASSNCUSTOMERGENDER,A.ASSNCUSTOMERADDRESS,A.ASSNCUSTOMERAGE,A.ASSNCUS > TOMERNAME,A.ASSNCUSTOMERID,A.RECID FROM > ASSNCUSTOMERMASTERTABLE A WHERE > (DATAAREAID=?) ORDER BY A.DATAAREAID,A.RECID > OPTION(FAST 1) > > As soon as i try to open the form axapta throws this > error and after > closing the error message the form opens. If i > create a new record in > the form the record is created but not saved, as > when i close the form > again it throws the same error message. > > Please help me out. > > Altamash > > > > > > > > __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com Sharing the knowledge on Axapta. Visit www.frappr.com/axapta for axapta friends. SPONSORED LINKS Business finance course Business to business finance Small business finance Business finance consultant Business finance magazine Business finance schools --------------------------------- YAHOO! GROUPS LINKS Visit your group "Axapta-Knowledge-Village" on the web. To unsubscribe from this group, send an email to: [EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. --------------------------------- --------------------------------- Jiyo cricket on Yahoo! India cricket Yahoo! Messenger Mobile Stay in touch with your buddies all the time. [Non-text portions of this message have been removed] Sharing the knowledge on Axapta. Visit www.frappr.com/axapta for axapta friends. Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/Axapta-Knowledge-Village/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/