Re: Limit Data Input
On Jan 31, 3:25 pm, JeffT <J...@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:
Probably simple but I can't figure this out.
I have three tables; jobs, invoices, and payments, all three are related by
a sales order number.
I have a form to enter each job in the jobs table with a subform for
invoices and a subform for payments. I want to limit entries for payments on
this form to match only the invoices related to the sales order number for
each job. Example: SO# 123 has invoice 456, only payment for 456 should be
posted in 123. Right now if someone mistakenly enters payment for 789 on SO#
123 the entry is still allowed because 789 exists in the table invoices. I
want a message to popup that says 789 is not related to SO# 123 and the entry
will not be allowed until the user goes to the SO# that 789 is entered under.
If the subforms are bound in a parent child relationship AND the SO#
is not even shown on the form (because it is not necessary) then the
payments will ONLY be for that SO#.
Ron
.
Relevant Pages
- Re: Business objects, subset of collection
... The application is for scheduling of payments of invoices and ... for the selected vendor ... subsets of the vendors / invoices: ... I have a Setfilter(DateTime filterDate) methods defined in the ...
(comp.object) - Re: Help with query
... One suggestion would be to consider if you ever need to split a transaction, such as for two partial payments on one invoice or for one payment covering two invoices. ... FROM tblSalesOrder SO INNER JOIN (tblDespatch D INNER JOIN (tblTransaction T ...
(microsoft.public.access.queries) - Re: Anything legal I can do?
... private agreement until he frequently missed payments then would jet ... frequently changes jobs and they have to trace him through tax then ... his house outright. ...
(uk.gov.agency.csa) - Re: Cant get query to work...
... I think I would start out with a query to sum payments against a specific ... INNER JOIN Invoices ON Orders.OrderID = Invoices.OrderID) ...
(microsoft.public.access.queries) - Re: A/R form creation?
... it is something like this month {i will work in month steps,but if a company has dept the amount will carry over to the nexxt month} the A company has purchased lets say 780USD, but in total i get paid for the amount of 500USD, the dept is 280USD and if in this month isn't paid it will start the new month with -280USD at their balance.... ... The absolute minimum is a new table for incoming payments, linked to Customers, and a union query to add amounts due and subtract amounts paid to calculate the outstanding balance. ... It would also help if you added an extra yes/no field to both tables to mark settled invoices and totally used-up payments so you exclude them from the union query, or it will introduce performance issues over time as the number of sales / payments increases. ... how you handle the settlement is a whole different ballgame! ...
(microsoft.public.access.forms) |
|
