Originally Posted by
akarmyguy01
I have a complex question that I am trying to get solved below is my database tables list and forms I have created. What I am trying to do is to have one form that when I open it and I click the find button that I have created it will pull up the record I have entered but when I click on the tab that says co-signer it automatically pulls open the separate form information for the co-signer has is already tied to the record ID of the form I just searched. At the same time on each form I would like to have a notes section that shows all of the notes entered for the file based on the relationship ID that ties the specific note to the primary record I searched for. How would I go about doing this?
Sure there are online databases that do what I am making but I can't have my information available to other people due to privacy laws.