Possible to have List & Card for same..

Xypher

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?)

tinoruijs

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.

Xypher

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

Are you trying to achieve a functionality like using the lookup of Salesperson Code on the Sales Order Card?

Xypher

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

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".

Xypher

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

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.

Xypher

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 ]

I guess I can try using SubForms.

tinoruijs

Xypher wrote:

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

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.

DaveT

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

Xypher

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