Where to define the drilldown page?

Alex_Chow

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

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

Alex_Chow

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

Please give an example of those ...

standard tables where drilldown is available on the page

Alex_Chow

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

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

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

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

lvanvugt

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

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

You don't need to create a form.

Just type the ID of the Page.

Alex_Chow

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

ara3n

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

Alex_Chow

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.