Results 1 to 1 of 1
  1. #1
    Join Date
    Dec 2004

    Unanswered: Form table storage in Access

    Hi all,

    Consider a form in which we have the usual elements - fields, checkboxes, optionbuttons etc. We also have some 2D tables, for example:

    _____________ Full Time __ Part Time __ Temporary __ Exits
    Toilet Cleaners

    This would be filled out by a business, who could have numbers in all the boxes or only a few of them.

    One way of storing this in Access is to create a new field in a table for each cell in the array, so we'd have FullTime_Managment PartTime_Management FullTime_Plebs etc.

    Is there an alternative method for storing data in this format?

    Some of the tables in the form may be quite sizable leading to hundreds of fields in the final database table for this form. I am looking for a solution that minimises the amount of coding/setting up one would have to do to establish the database and also to modify it at a later date.


    Neon Angel
    Last edited by neonangel; 12-06-04 at 18:22.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts