I thought this would be simple, but apparently I'm missing something. I'm even not really sure if this is a conditional lookup question, but here is my problem.
I need to create something that emulates the Quickbooks deposit function. Simply put, I have a parent dbf that is holding the deposit information i.e. check number, date, amount. A child dbf holds the split information for each deposit which will total to the parent amount. So far - so good. But in the child dbf I need to allow the user to access a third database called Receivables, that has the invoices in it.
So at the top of this, the user would enter a check payment amount (gross), then go into the child and enter the information based on how the check has been split up. (There may be one or more invoices the main check is paying.) Actually in Quickbooks, all the open invoices are presented to the user and he/she only need to check off the ones that the check is paying. That would be good too!
My issue is how do I put together a table lookup into receivables based on the name of the check maker (which exists in all three dbf's) Ideally, the user should be presented with a list of all the check makers in the receivable database which are not already paid. When I try to use the filter function, I can only filter on the fields in the receivables dbf, so I'm kind of at a loss as to what to do.
Any thoughts are most appreciated.
Charlie
I need to create something that emulates the Quickbooks deposit function. Simply put, I have a parent dbf that is holding the deposit information i.e. check number, date, amount. A child dbf holds the split information for each deposit which will total to the parent amount. So far - so good. But in the child dbf I need to allow the user to access a third database called Receivables, that has the invoices in it.
So at the top of this, the user would enter a check payment amount (gross), then go into the child and enter the information based on how the check has been split up. (There may be one or more invoices the main check is paying.) Actually in Quickbooks, all the open invoices are presented to the user and he/she only need to check off the ones that the check is paying. That would be good too!
My issue is how do I put together a table lookup into receivables based on the name of the check maker (which exists in all three dbf's) Ideally, the user should be presented with a list of all the check makers in the receivable database which are not already paid. When I try to use the filter function, I can only filter on the fields in the receivables dbf, so I'm kind of at a loss as to what to do.
Any thoughts are most appreciated.
Charlie
Comment