Active Key

ajmalsherif
ajmalsherif Member Posts: 111
edited 2008-10-30 in NAV/Navision Classic Client
Hi

I have recently restored a large Nav native Db v4 Sp1 onto a test server, however when i select a customer on the Sales Order or Sales Invoice i get the following message:

The Credit Card Transaction Table does not have an Active key that starts with the following fields: Document Type, Number andTransaction Type

Any suggestions would be most helpful

Comments

  • kapamarou
    kapamarou Member Posts: 1,152
    You should use debugger to see where the error occurs.
    There could be code somewhere that says:
    SETCURRENTKEY(...)
    Or a form that you open has a tableview using that key.

    In Credit Card Transaction Table do you have a key that starts with the following fields: Document Type, Number and Transaction Type?

    Is that key enabled?
  • ajmalsherif
    ajmalsherif Member Posts: 111
    Many thanks \:D/
  • David_Singleton
    David_Singleton Member Posts: 5,479
    I will put odds on that the debugger will not show anything.

    Most likely there is a flow field created on the Customer table (18) and the Sales Header (36).
    I will also bet that the issue is that the backup restore did not finish.

    To find this out go to Tools Backup Restore and see if it asks if you want to complete the restore process.
    David Singleton

Categories