Bound Denormalized Form (1 Viewer)

Status
Not open for further replies.

Pat Hartman

Super Moderator
Staff member
Local time
Today, 17:21
Joined
Feb 19, 2002
Messages
30,173
This database contains two examples (using the same technique) of how to take data that is properly normalized and display it so that it looks like a spreadsheet (rows displayed as columns) but is actually updateable. The technique uses a separate subform for each column so it is limited but works well for 12 months. I don't know what a practical limit might be. You'll need to experiment.
 

Attachments

  • BoundDenormalizedForm130810.zip
    1.5 MB · Views: 1,367

Pat Hartman

Super Moderator
Staff member
Local time
Today, 17:21
Joined
Feb 19, 2002
Messages
30,173
Here's an updated version along with some documentation. I also added a report built using a variable crosstab. The technique creates an intermediate table to hold the column header values and assign them a number from 1 to x (width of report - probably not more than 20).
 

Attachments

  • BoundDenormalizedForm20190212.zip
    1.5 MB · Views: 146

isladogs

CID VIP
Local time
Today, 22:21
Joined
Jan 14, 2017
Messages
14,038
Hi Pat
Thanks for the update some six years after the original example.
I've only just spotted and approved your new post. As I'm sure you know, mods aren't informed when a post is made to this area.
Please see sticky thread about reporting your own post as that usually triggers a faster response.
 
Last edited:
Status
Not open for further replies.

Users who are viewing this thread

Top Bottom