Maybe you can use a RESIDENT LOAD, but maybe you don't need it. Based on what criteria do you want to assign the auto number to your records?
Maybe use just a
Recno() as Autonumber,
in your three table loads.
If your autonumber is based on date, a
Autonumber(Application_Date) as Autonumber,
should work, the autonumber() is done across multiple table loads as well.