Hi,I am trying to setup my tables, but before I started, is like some guidance on how to set them up. Here's the plan:
Each day, a person will enter about 200 values in a form. Currently they enter them in a spreadsheet. With that being said, each employees entries will count as one record/occurence for that day/shift. For example the fields might be: name, date, shift, tag1value, tag2value, tag3value, etc etc, - tag180value. These are filled out each day and later on, I will want to search this day and be able to see the form with all these values filled in. Also, I may add/change the entry names occasionally. Ideally, I would like a table named "tags" that I could add and change and the form would pull everything into, however I didn't think this was doable.
Anyone have any suggestions/solutions.