Possible to have List & Card for same..

Xypher
Xypher Member Posts: 297
edited 2008-04-01 in NAV/Navision Classic Client
Is it possible to have one form display both a table list & card?

(And be able to edit and save any record changes without the Card & List wrestling?)

Answers

  • tinoruijs
    tinoruijs Member Posts: 1,226
    Xypher wrote:
    Is it possible to have one form display both a table list & card?

    (And be able to edit and save any record changes without the Card & List wrestling?)

    Do you mean you only want 1 form?
    Yes, it is possible.
    Beware though that it will be very easy to accidently modify a record. On the other side; Insert a record will also be easier.

    Like a famous Dutchman said; every advantage has his disadvantage. :wink:
    Tino Ruijs
    Microsoft Dynamics NAV specialist
  • Xypher
    Xypher Member Posts: 297
    Well, I'm curious how I can get around this error I keep getting...

    If I select a record from the list (which updates the card information) and I alter the information then attempt to select another record from the list it tells me.. "Tablename cannot be modified in this form."

    It just appears there is a conflict between the List & Card if the information does not match.

    I have tried numerous different ways of attempting to save the record before retrieving the next, clicked, record from the list but have not found a solution.


    Any ideas?
  • tinoruijs
    tinoruijs Member Posts: 1,226
    Are you trying to achieve a functionality like using the lookup of Salesperson Code on the Sales Order Card?
    Tino Ruijs
    Microsoft Dynamics NAV specialist
  • Xypher
    Xypher Member Posts: 297
    I'm trying to implement one form to provide both a 'Customer List' and 'Customer Card' functionality applying to the same table.

    It shows a generalized list (2-3 columns) of the customers, so you can do an easy search, and then the Card provides the ability to modify, delete, insert records while also applying certain "rules" to each field to make sure correct information is inserted/modified.
  • tinoruijs
    tinoruijs Member Posts: 1,226
    Ok. That can be a challenge. :-k

    You could try to use the function CurrForm.UPDATE; It's often the solution when you get error ".. cannot be modified in this form".
    Tino Ruijs
    Microsoft Dynamics NAV specialist
  • Xypher
    Xypher Member Posts: 297
    tinoruijs wrote:
    You could try to use the function CurrForm.UPDATE; It's often the solution when you get error ".. cannot be modified in this form".

    Yeah I've tried using COMMIT, MODIFY, UPDATE, etc...

    And almost in all spots I can conceive of. Either get a repeat error "... cannot be modified in this form." or "You cannot make any changes in the database until a transaction has been started."
  • tinoruijs
    tinoruijs Member Posts: 1,226
    Xypher wrote:
    tinoruijs wrote:
    You could try to use the function CurrForm.UPDATE; It's often the solution when you get error ".. cannot be modified in this form".

    Yeah I've tried using COMMIT, MODIFY, UPDATE, etc...

    And almost in all spots I can conceive of. Either get a repeat error "... cannot be modified in this form." or "You cannot make any changes in the database until a transaction has been started."

    Then I guess it's impossible what you want..

    I would stick to the standard NAV functionality.

    Maybe instead of starting with card like standard NAV does, you could begin with the list as link in the menu. And use the standard Shift+F5 to open the card.
    Microsoft Dynamics Entrepreneur works like that. It starts with list and when you push F3 the card is opened with an empty record.
    Tino Ruijs
    Microsoft Dynamics NAV specialist
  • Xypher
    Xypher Member Posts: 297
    tinoruijs wrote:
    Then I guess it's impossible what you want..

    I would stick to the standard NAV functionality.

    Maybe instead of starting with card like standard NAV does, you could begin with the list as link in the menu. And use the standard Shift+F5 to open the card.
    Microsoft Dynamics Entrepreneur works like that. It starts with list and when you push F3 the card is opened with an empty record.

    I suppose I just wanted to provide the ability to list & alter on a single interface (Since they use the same SourceTable I figured, why not?).

    [And on the side reduce some form usage and save some money :wink:]

    I guess I can try using SubForms.
  • tinoruijs
    tinoruijs Member Posts: 1,226
    Xypher wrote:
    [And on the side reduce some form usage and save some money :wink:]

    I guess I can try using SubForms.

    A form is not that expensive. I think your hour rate is more than the cost of one form. :)

    Good luck with the subforms.
    Tino Ruijs
    Microsoft Dynamics NAV specialist
  • DaveT
    DaveT Member Posts: 1,039
    Hi Guys,

    Was curious about this one so I tried it out :-k

    I took a standard customer card 21 and added a table box. I could edit in the list or the card no problem.

    I think the conflict comes when you make the list (table box) ineditable
    Dave Treanor

    Dynamics Nav Add-ons
    http://www.simplydynamics.ie/Addons.html
  • Xypher
    Xypher Member Posts: 297
    DaveT wrote:
    Hi Guys,

    Was curious about this one so I tried it out :-k

    I took a standard customer card 21 and added a table box. I could edit in the list or the card no problem.

    I think the conflict comes when you make the list (table box) ineditable


    Ahh! That was the problem. Thanks for bringing this to light Dave

Categories