I am tracking five databases in one to connect related tracking numbers, six tables altogether.

Main Issue table: tracking all of the below numbers as they relate to each other. Each of these tracking number types has it's own table.

Whiteboard# and associated fields
Ticket# and associated fields
Defect# and associated fields
Workaround# and associated fields
DCR# and associated fields

Not all tracking numbers will necessarily be used for each Main Issue.

How do I make a form that will:

1. Autonumber a new Main Issue for each new issue
2. Add the tracking number to the Main Issue table and to it's own tracking number table.

For example:

Main issue 1:
Whiteboard# A27 and their resolution
Ticket# 425 and their resolution
Defect# (nothing)
Workaround# AA-1
DCR# 14-537

Main issue 2:
Whiteboard# (nothing)
Ticket# 426 and their resolution
Defect# A1-529
Workaround# AA-2
DCR# (nothing)