Hello all! I am very out of touch with access and would appreciate if anyone has an opinion on my problem.
I have a db I'm building that relies on a combination of 5 things that each combination has a different static set of results.
Currently I have two tables that link together as one is the combination of 5 with an ID number and the 2nd table is the results, as I would suppose a 1 to 1 relationship. I'm guessing I created more work for myself in doing the split, but need better opinions if anyone is willing.
The other possible quandary is that in my form for adding new records, I have to have it check for duplicates in the 5 combinations. I have this coded, and I am pretty sure I can switch it to just the first 5 columns if I need to combine the tables, but I just wanted to mention it in case.
Thank you immensely to any who offer opinions for my stoop self.