I am sorry in advance if this is not the proper forum for this topic.
I am hoping someone on here can provide some structural and technical guidance for putting together a database in Access 2010.
I am trying to pull together a database that tracks different awards my club has won. We want to include several fields:
The year the award was won.
The name of the award
Type A tag for the award
Type B tag for the award
Type C tag for the award
The tags will be fixed lists, so I want the user to pick from choices in each type.
I was thinking the best way to approach this was to create one master table for data entry and then three other tables that would contain the tag lists. All of the tags are static and I want to make sure everyone who uses the data would be picking from the same values. At the same time, in the future, we may need to add additional tags to the respective lists, so I want to make it very easy and universal across the database. Therefore, I was thinking I would just use 3 lookup columns in the main table that point to the respective sub-tables. (I hope you are with me.)
Then, I want to be able to create a form where we can basically pull up records based on user's data tag choices. I guess they are basically just functioning as filters. However, I want the filters to actually look at the values in the original tag tables, so all the possible choices show. Some tag records may also contain more than one tag, so i want to be able to search by individual tags.
I hope I have explained myself well. I have been spending hours on this and I just am not making any progress. I'd really appreciate if someone out there on the net could swoop in and give me some guidance!
Thanks!