Invoice/Payment form set up

[Annie]

Hello. Thanks to one of the table designers I am further
along on a project to build forms to track membership dues
and payments. However, I can't seem to get the
form/subform correct. I have Members that are assigned a
Member Category, and are assessed dues based on that
category. For example, John Doe has an "Individual"
Member Category so he owes $80, and then he pays $80.

I'd like the membership dues information as well as the
payment information to be on a tab of my Member form. It
seems as though I should have Member Dues as a form with
Member Payments as a datasheet view subform. And then I
should attach the Member Dues/Member Payments to the
Member form. But it's not going so well. I'd appreciate
any help you can give. Below, I've attched the table
design. Thank you in advance!

tblMembers
============
lngMemberID
lngMemberCategory [FK to tblMemberCategory]
strName
strAddress
etc etc

tblMemberCategory
============
lngMemberCategoryID
strMemberCategory

tblDuesHeader
==========
lngDuesID
lngMemberID [FK to tblMembers - tells you who owes these
dues]
dteDateDue
etc etc

tblDuesLineItem
===============
tblDuesItemID
lngDuesID [FK to tblDuesHeader]
lngDuesItemTypeID [FK to tblDuesItemType - allows you to
differentiate between basic dues, late fees, addtional
items, etc etc]
curAmountDue
dteDateCreated
etc etc

tblDuesItemType
===========
lngDuesItemTypeID
strDuesItemType

tblPaymentsHeader
===========
lngPaymentID
lngDuesID [FK to tblDuesHeader]
dteDateCreated
etc etc

tblPaymentsLineItem
==============
lngPaymentItemID
lngPaymentsID [FK to tblPaymentsHeader]
lngMemberID [FK to tblMembers]
lngType [FK to tblPaymentTypes - allows you to
differentiate between different types of payments,
i.e. "fake" money]
curAmount
dteDateRemitted
etc etc

tblPaymentTypes
===========
lngTypeID
strType