I am extremely new to Access overall and am using Access 2010 to build queries and forms, so the easier explained the better. I do not have a clue on writing code and am trying to learn as I go.
What I have is several tables that each contain specific data that will be tied to one form in the end. The problem with this is there are 83 columns titled "References", each respectively named correctly (Reference 1, Reference 2, Reference 3, etc...). These are to be tied to a another table through a common title. The problem is many of these "References" are empty (NULL). I may have one "Common Title" that has no "References" what so ever and another that may have up to 83 "References".
I would like to be able to build the forms to show each "Common Title" individually with its respective "References". I have looked at several ideas and ways of doing this with no answer as of yet.
If there is any help it would be greatly appreciated.