I'm 2 hours OLD in developing in a ACCESS application so hopefully someone can be gentle on me and help me out, lol.

Table structure:
LOA.DBF CLIN.DBF
pk_loa pk_cllin
loa_number clin_no
loa_amount clin_amount
loa_descr clin_sats
fk_clinid
loa_sat_proj
loa_sat_act

How do I generate a random number to serve as the pk_cllinid and how do I capture that number in a global variable. I know if Vfp, I could simple assign PUBLIC m.mypkid etc etc. How do I do that in ACCESS or vBasic?

Next...

I want the user to be able to select a button at the bottom of the LOA Add screen that would allow them to input mulitple CLINs if need be. An LOA can have multiple CLINs. So after the user enters the first CLIN data, I want them to push the save and add another CLIN button. I want the record to write to the CLIN.dbf and also update the LOA dbf with the fk_clinid. The screen should then refresh ready for the user to input a new record and go through the same process.

I apologize if I confuse, like I said, I am a couple hours into the ACCESS / vB world...ONLY becasue I dont have my vFp software with me ! lol