Parent / subform

[Guest]

Hi. I think I have a problem with my setup for my forms.

My main form is Individuals (based on tblContacts)and it has a subform set
upfor payables.
The payables set up is: form called DuesLineItem (based on tblDuesLineItem)
which has a subform called PaymentsLineItem (based on tblPaymentsLineItem).
This allows me to have dues each year and show the pertinent payments (Dues
is the one, Payments is the many)

tblDuesLineItem
DuesItemID
TypeID (2 is check, 6 is "cashed-in" hours)
ContactID
AmountDue
DateCreated

tblPaymentsLineItem
PaymentItemID
DuesItemID
Amount
DateRemitted

But something isn't right. I have 2 Contacts that are related, paying dues
together. I set up one Contact to owe $99 ($93 as a check and 6 as
"cashed-in" hours), and one Contact to owe $1 (1 "cashed-in" hour). So I
would expect 2 Dues entries and 3 Payments entries. Instead, here's what I
have:

DuesItemID: 15 AmountDue $99.
Associated PaymentItemID: 854 TypeID: 2 Amount: $93.
Associated PaymentItemID: 859 TypeID: blank (should be 6) Amount: blank
(should be 6 hours)

DuesItemID: 16 AmountDue $1
Associated PaymentItemID: 857 TypeID: 6 Amount: $1

So, I'm wondering why 1) PaymentItemID 859 is messed up and 2) my
DuesLineItem/PaymentLineItem form is blank on my Individuals form unless I
move between records (some requrey issue perhaps where the info isn't on
current??) and PaymentLineItem 859 never shows up associated with the Dues or
Contact.

I appreciate your help is sorting out these form issues. Thanks!

 

[Guest]

Guess I'd better post this in the database design section!