Hey guys.
so in order to understand what i am trying to do, i need to explain what i am building
I am building a portal for the members of a dog organization. I have a few datasheets that im working off but what i need help with is only related to 2 sheets. I am using a “helper” table in order to record and submit a form to our head office and i have a database of dogs with all they relevant information.
Currently, the owner of a stud male has to submit a mating certificate to the office. in my form that i have created, me as the stud dog owner, can select my dog from a drop down menu, after that, i have a bunch of text entry details for the details of the female.
My question is, on my helper sheet, i also require to bring in all the info about the male, for example, registration number, microchip number, working qualifications. i have all this data in my dog datasheet but i would like to automatically bring it into my helper sheet by simply selecting the name of the dog from my drop down menu. is there a way to do it without it showing on the mating certificate form?