Hi all, head a bit sore from continual banging head against monitor 
Could someone have a look at the attached VB project and database? it's just a proving ground to get the principals of adding records to master/child tables. In the form load event I call sub routines to open connection and recordsets from the database. Then it ascertains the last TransactionNumber in tblTransaction, adds 1 to it and writes this record to the table. The "fun" starts when I try to add a record to the linked table tblTransactionDetails. The linking field is TransactionNumber, but no matter what I do i cannot get it to create a record in tbltransactionDetails! Once I get this sorted then the rest shopuld be straightforward but it's giving me a nightmare. Time's running out on my project and I'm in the doo doo if I can't get this done
Hope someone can be of help, Lol
Could someone have a look at the attached VB project and database? it's just a proving ground to get the principals of adding records to master/child tables. In the form load event I call sub routines to open connection and recordsets from the database. Then it ascertains the last TransactionNumber in tblTransaction, adds 1 to it and writes this record to the table. The "fun" starts when I try to add a record to the linked table tblTransactionDetails. The linking field is TransactionNumber, but no matter what I do i cannot get it to create a record in tbltransactionDetails! Once I get this sorted then the rest shopuld be straightforward but it's giving me a nightmare. Time's running out on my project and I'm in the doo doo if I can't get this done
Hope someone can be of help, Lol
