I just had a thought about enhancing a database that I created and use everyday and I am wondering if it is possible to do something to give me a view I would like possibly in a tabbed form or just any form I can create. If I look at one of my tables I see the plus sign in the far left and if I expand on it I see all records relating to that record based on the relationships set up.
Can I change the relationship using VBA for a specific form? That way I could leave original relationship intact. Another thought I had while typing this out was to create a custom query in the form that would essentially do the same thing. I am trying to expand my Access abilities here and hoping you folks can point me in the right direction as you always have with your expert knowledge and experience.
Thanks in Advance