D
Daniel urich
From: "Chey" <[email protected]>
Subject: need help on the best way
Date: February-25-08 3:35 PM
I log in what we call bills
I have created a form where I log in the amounts.
In the form header I have 2 combo boxes to look up information.
THis is the part I am unsure if is right or if there is a better way.
I have a combo box that I assign a "batch number" 1-8 if I am working on
batch 1 when I choose my billing month and choose my provider number it
creates a new record and under theMonth it puts the billing month and
provider number. But then it needs to refresh with the provider
information.
If this is not a good way what should I do.
I have two tables.
tblChild Care Providers
tblGrantCompletion
Child Care Providers is there persoal information ie Name, addy, phone
tblGrantCompletion is linked by ICCIS # (that is like our ID) and has
monthly information on each provider.
So when a provider turns in a bill for January a new record is inserted into
the GrantCompletion table for me to work off of.
Thanks
Cheyenne
Subject: need help on the best way
Date: February-25-08 3:35 PM
I log in what we call bills
I have created a form where I log in the amounts.
In the form header I have 2 combo boxes to look up information.
THis is the part I am unsure if is right or if there is a better way.
I have a combo box that I assign a "batch number" 1-8 if I am working on
batch 1 when I choose my billing month and choose my provider number it
creates a new record and under theMonth it puts the billing month and
provider number. But then it needs to refresh with the provider
information.
If this is not a good way what should I do.
I have two tables.
tblChild Care Providers
tblGrantCompletion
Child Care Providers is there persoal information ie Name, addy, phone
tblGrantCompletion is linked by ICCIS # (that is like our ID) and has
monthly information on each provider.
So when a provider turns in a bill for January a new record is inserted into
the GrantCompletion table for me to work off of.
Thanks
Cheyenne