Re: Asking too much?? Form-subform based on 4 tables, one is a junction table.
- From: "Sam" <sampahkertas@xxxxxxxxx>
- Date: 27 Jun 2006 21:37:27 -0700
No replies? Anybody? Suggestion? Comment?
-Sam
Sam wrote:
I have a problem with creating a form from tables involving a junction
table. What I learned from this group is: Create a form based on one
one-table and a subform based one many-table, and have the combobox in
the subform be based on query on the-other one-table.
My situation:
tblCustomer one-many tblSales
tblSales one-many tblReceipt_Allocation
tblReceipt one-many tblReceipt_Allocation
One receipt from a customer can be used to pay more than one invoice.
And one invoice can be paid by more than one payment/receipt.
I have created a form frmReceipt (recordsource: tblReceipt) and a
subform fsubReceipt (recordsource: tblReceipt_Allocation).
In the subform, a combobox is used to pick out invoices that will be
paid. Then the user will enter the payment amount for each invoice,
manually splitting the payment amount (tblReceipt doesn't have a field
for total receipt amount).
Currently this combobox is not filtered by customer. Instead, it will
list all open/not fully paid sales. So, a payment can pay for sales of
more than one customer, which isn't right.
What I would like the user be able to do when receiving a payment is:
Open a form, pick a customer, enter payment info (date etc.), pick from
a list of open invoices, allocate the payment to one or more invoices.
Could somebody please help. Thank you in advance.
-Sam
.
- Follow-Ups:
- References:
- Prev by Date: Re: In joining 2+ records together seperated by commas replace last comma with 'and'
- Next by Date: Re: Moving Records of one table to another
- Previous by thread: Asking too much?? Form-subform based on 4 tables, one is a junction table.
- Next by thread: Re: Asking too much?? Form-subform based on 4 tables, one is a junction table.
- Index(es):
Relevant Pages
|
