Open Table1 in design view, click on the field ISSUEID and then on the key
icon to make the field the primary key. Save.
Open Table3 in design view, click on ISSUEID and set the datatype to Number
- Long Integer. Save.
Click on menu TOOLS - Releationships. Click on Show Tables icon and double
click Table1 and Table2 to add them to the Relationships window.  Click on
Table1 ISSUEID field and drag to Table2 ISSUEID field.  Select Enforce
Referential Integerity and Cascade Update Related Fields.  Save.
     NOTE - If there is a problem in saving then run an unmatch query to
find records in Table2 with ISSUEID not in Table1.  Correct.  Return to
Relationships and finish.

Use a form and subform linked Master/Child on ISSUEID.

As you add records to the subform it will add in the ISSUEID automatically.  
It is not even necessary to display it in the subform.