Where to define the drilldown page?

Alex_Chow · 2010-01-14

When you create a new ledger table and would like the user to drilldown to the ledger table using pages, where do you define the drilldown page? The only properties on the table are the drilldown forms.

ara3n · 2010-01-14

forms do not exists on RTC so drilldown Form = drilldown Page.

Alex_Chow · 2010-01-14

ara3n wrote:

forms do not exists on RTC so drilldown Form = drilldown Page.

Where's the drilldown page property on the table?

And I'm not talking about the DrillDownFormID property on the page itself.

If you check the standard tables where drilldown is available on the page, the DrillDownFormID is not even defined, yet you can drilldown?

lvanvugt · 2010-01-14

Please give an example of those ...

standard tables where drilldown is available on the page

Alex_Chow · 2010-01-14

Run page 30, click on the Quantity on hand. It'll drilldown to the item ledger for that item.

Where is it defined that when I drilldown on the Quantity on Hand on the page it'll bring up page 38? And the DrillDownFormID is blank!

lvanvugt · 2010-01-14

Probably Quantity on Hand is a US field, but more or less the same as the Inventory field (68).

This field is a FlowField based on the Item Ledger Entry table and on this table the DrillDownFormID is defined. This is what does 'the trick'.

Alex_Chow · 2010-01-14

lvanvugt wrote:

Probably Quantity on Hand is a US field, but more or less the same as the Inventory field (68).

This field is a FlowField based on the Item Ledger Entry table and on this table the DrillDownFormID is defined. This is what does 'the trick'.

Wow... This is an undocumented 'trick'!

Basically, what I did was create a regular form with the same name as the page, set the DrilldownFormID on the table. Then magically, it worked!

Apparently, you cannot specify the Page on the DrilldownFormID on the table, but you can specify a page on the DrilldownFormID on the page.

Gotta be a bug? :bug:

Alex_Chow · 2010-01-14

After you define the drilldown form on the table, you can delete the form and the drilldown will still work on RTC.

lvanvugt · 2010-01-15

As far as I know this is not 'undocumented'. This is the way to work with drilldown forms for FlowFields.

In this repsect (as with many) Pages = Forms.

Alex_Chow · 2010-01-15

lvanvugt wrote:

As far as I know this is not 'undocumented'. This is the way to work with drilldown forms for FlowFields.
In this repsect (as with many) Pages = Forms.

Forms and pages are different object types. I know the drilldown forms on forms for tables. But there's no where you can specify Drilldown Pages.

So if you're developing an application specifically for RTC, not the class client, you'd be forced to create form objects.

ara3n · 2010-01-15

You don't need to create a form.

Just type the ID of the Page.

Alex_Chow · 2010-01-15

You do. If you don't have a form, you'll get a compliation error when you try to save.

ara3n · 2010-01-15

I can set DrillDownFormID to any number and can save the table just fine.

Alex_Chow · 2010-01-15

ara3n wrote:

I can set DrillDownFormID to any number and can save the table just fine.

Well I'll be damn... Couldn't swore I got an error when I just typed in the ID.

Where to define the drilldown page?

Comments

Categories