Make payments (newbie needs help)

[paliman]

Hi everybody. This is my first post here.

I have these 3 tables:

Invoice headers
Checks
Payment orders (2 fields: Number and Date)

Tables are related by a field named “PO Num” (payment order number), which is the PO's key.

I need to design a procedure to make my payments, something like this:

1-Add a new payment order to my table
2-Select from a list of unpaid invoices which ones to include in my PO (may be one or more)
3-Write checks to cancel the invoices (also may be one or more checks)

I don't mind if I have to add extra fields or do it in more than one step. I'm a real newbie here, so please be kind. Any help will be greatly appreciated

 

[Rob.Mills]

You could setup a form for the new payment order. Inside the form setup a listbox (with multi-select) that has a recordsource of the invoice table filtering the unpaid ones.

Not sure how to help you with writing the checks. Have you setup the db to print the checks out for u?

 

[RichMorrison]

pali,

It sounds like:
1 Payment Order is connected to 1 or more Invoices,
1 P O is connected 1 or more Checks

The first question is how are Invoices connected to Checks ?
Is 1 Check connected to 1 Invoice or to 1 or more Invoices ?

You must decide that.

If 1 Check is connected to exactly 1 Invoice then you will want a table like:

PO_To_InvoicesChecks
> PO number,
> Invoce number,
> Check number,
other fields.....

The ">" fields would be the unique key and a PO number value could repeat in several records.

That's a start.

RichM

 

[paliman]

No, no. I write the checks with my old parker and then I enter the data into the db

What I need is something like a form with 2 subforms, but I wasn't able to create them because of the relationships. They should be

one PO - many invoices
one PO - many checks

Thanks. I hope it's clear enough.

 

[paliman]

I'll put an example:
Invoice #1: $15
Invoice #2: $ 3

I pay this two invoices with 3 checks, each one for $6 with different due dates.

Thanks again

 

[paliman]

I'll put an example:
Invoice #1: $15
Invoice #2: $ 3

I pay this two invoices with 3 checks, each one for $6 with different due dates.

Thanks again