I have two tables. Info and Exam.
I have a form for info that has an autogenerated id linked to a field in the exam table called infoID.


On the info form I have a control button to open the exam form. It then shows exams for that infoID. If I add another exam I want the Info ID field to be the same as the original ID form the ID table. I now can enter it manually but I really want it to default to the current patient I am working on.
I also have an attachment field on my exam table. I want that field to default to a drawing that I can edit. A. how do I do this, and B. I have used microsoft paint and when I select the drawing I did it only opens as a picture that can't be edited.
thanks, mark