Index on Form page?

[dkeiffer]

Is there a way to put an index on a Form page?
Thank you,

[Brian_Houghton]

Hello,

Thanks for writing. Do you mean an index to other forms? If so, you can do this by creating an empty form that you set to be the start form for the database. Then add buttons to the form that have the action of jumping to other forms. On the forms that are jumped to, be sure to add a "back" button to jump back to your starting form.

Here's a tutorial you can use for reference: http://www.ddhsoftware.com/knowledgebase.html?read=304

Hope this helps!

[dkeiffer]

I guess I should have said a List.
That would be a list of the records that are in the database. Can this be put on a form?
Thank you,

[Brian_Houghton]

Hello,

Thanks for the clarification. The feature you are requesting is currently not available in HanDBase Forms. I do know it is a feature that Dave has expressed interest in but it probably wouldn't see the light of day until there was a major file format revision. That would be quite some time in the future.

Sorry!

[simonclivehughes]

For further clarity, are you saying that it is not possible to display data in a table format from within HanDBase?

Cheers,

[Brian_Houghton]

Hello,

It's absolutely possible to display the data in a table format. Record list view is essentially a table of data.

What I'm referencing is the ability to display a subset of a table, for example: a range of related records, on an individual edit record form. That's what is not possible at this time.

Hope this clarifies.

[simonclivehughes]

Hello,

It's absolutely possible to display the data in a table format. Record list view is essentially a table of data.

What I'm referencing is the ability to display a subset of a table, for example: a range of related records, on an individual edit record form. That's what is not possible at this time.

Hope this clarifies.

Thanks Brian, I thought that was the case!

What I would love to see for your example, is a control/method with the flexibility of Excel's VLOOKUP / HLOOKUP, with nesting ability in the logic. I recall (been using HanDBase a long time on PPCs) setting up logic statements but you can only have one instance, right? If I recall from just reading the manual, you can't have a nested IF - THEN structure can you? (If so, to what depth?)

Specifically then, can you use a field's contents as an indirect address for another (so the field value is used to lookup a specific record based on one field and then use an offset to find the indirect field within that record)? With an Excel table, I would do this by using HLOOKUP to get the offset value from, for example, a horizontal header row and then use that with a different indirect field value VLOOKUP to get the correct cell value from a row lower in that column of the table. In this case, the table shows losses of different coaxial cables (in columns) and the losses at different frequencies (in rows). The object is to choose a cable type and then utilize the specific losses at specific frequencies, displaying typically about 6 different results (in a table format).

Cheers,

[Brian_Houghton]

Thanks for your thoughts. Definitely something to think about!