I am looking for the best approach to a complex set of forms and their interaction.
Environment:
Microsoft Access 2007 ... Jet Be (at the moment)
Main Form
Recordsource is TxnHdr (Transaction Header) key is TxnID
Subform
Recordsource is TxnDtl (Txn Detail) Linked by TxnID .. Key is...