Present a database 'view' as if it were a table?

Question

Filtered rows would be nice but really not essential. A pure standalone table like view which allows sorting and filtering of results as you do now would do the job perfectly.

One thing I just remembered is that Access asks which field is to be used as a key when it is linked. Perhaps dbFront could do something similar. Just a thought :)

Answer 1

Thank you for your request. There are many situations where this makes the best sense.

At the same time I would like to caution users asking for a stand-alone view that they might be missing an alternate solution that would serve them much better.

The problem with a stand-alone view is that the result set is largely divorced from the underlying data structure. This means that dbFront can't automatically generate lookups, use indexes or bring in other related tables.

For example, if you want your users to look at a specific table:

• possibly filtered,
• with the related data expanded,
• some summary information...

... then you would be further ahead by creating and joining a small view to the current table to supply the summary information.

NOTE: Please vote on this Feature Request if it interests you.