Dexterity - Two Questions Tables/Scroll Window 1

[Borvik]

Ok - now that I've got menus working I can continue on with my application.

I'm going to need tables created when the application is installed (via chunk). Reading up on this - the best way to do this is with triggers. I found the example script at winthropdc.com under the "Dexterity FAQ Articles" section of the training page. I've added my table to a Table Group as the top of that example said, but the table still doesn't get created - causing the Grant access procedure to fail.

I have a feeling it has to do with the following line found at the top of that example:
"If you are using Series 3rd party, you must also create entries in the SY_Pathnames table to ensure that the new tables are created in the correct datbases."

Could you elaborate on how to do that Dave - as someone installing this wouldn't have it entered into that table before hand?

The second thing is I'm trying to create an alternate SOP_Entry window. Mainly I'm trying to add fields to the Scrolling Window. These fields are from tables already attached to the form and I can't seem to get them to populate correctly - namely Qty On Hand from the table IV_Item_MSTR_QTY, it always shows 0 when I know that is not the true value. I'm pretty sure I've got to attach a script (via trigger) to one or more LINE_FOCUS events, but I'm not sure on the process for this either.

Any ideas?

 

[winthropdc]

Hi Borvik

The following KB articles should help you with the table creation.

https://mbs.microsoft.com/knowledgebase/KBDisplay.aspx?scid=kb;en-us;874554

https://mbs.microsoft.com/knowledgebase/KBDisplay.aspx?scid=kb;en-us;910700

https://mbs.microsoft.com/knowledgebase/KBDisplay.aspx?scid=kb;en-us;919347

As for scrolling windows, only fields from the linked table will be automatically displayed on the scrolling window. Fields from any other table will need focus triggers on the scrolling window on the TRIGGER_FOCUS_FILL event to display the values and TRIGGER_FOCUS_CHANGE to save the values.

Hope this helps.

David Musgrave [MSFT]
Senior Development Consultant
Escalation Engineer - Great Plains
Microsoft Dynamics Support - Asia Pacific

Microsoft Dynamics (formerly Microsoft Business Solutions)

http://www.microsoft.com/Dynamics

Any views contained within are my personal views and
not necessarily Microsoft Business Solutions policy.
This posting is provided "AS IS" with no warranties,
and confers no rights.

 

[Borvik]

I figured that would be TRIGGER_FOCUS_FILL (I won't need to save, but thanks for that info as well) - thanks for confirming that for me, I've been playing with all of them. Now I know where to focus my efforts.

It also figures, as soon as I post I figured out some way to get the table created - by adding it to the series Sales (forcing it to choose the Company database).

Though that last KB article looks like exactly what I was looking for in regards to the SY_Pathnames table - I'll have to play with that to see if I can't keep the table in the 3rd Party series.

As always Dave - you've been a great help.