A
Adiankur via AccessMonster.com
I am attempting to develop a form that will creat 14 new records in a billing
table, based on date range, for every entry in an authorized service table.
Some information on the form need only be noted once, such as name, client
and service, while there needs entries for the 14 new records. I will note
the tables, relationships, and form set up following.
Tables:
(P+F)=(Primary to Foreign)
Staff table(P+F)Staff Assignments(F+P)Authorizations(F+P)Clients
P
F
+
+
F
P
Billing Table Service Codes
Those are the tables and to which table they are linked
Here is how I would like the form to set up
Following are 1 Entry only
(staff name, client name, service code all defined through the staff
assignment table)
Billing Period (will define dated entries for service) example is 6/9/2006
Staff Name (only need once per set of entries)
Client Name (only need once)
Service Code (only need once)
******Following Entries should have 14 per form but each being a different
record****
Date of service (derived from the billing period 14 entries auto fill)
Example 5/27/06 5/28/06 5/29/06----all the way up to billing
period 6/9/06
Time of service (manual entry for each date of service)
Billing Status (y/n entry for each date)
Signed form (y/n for each date)
Signed Note (y/n for each date)
Units billed (manual entry for each date of service)
Is there a way to set this up? I dont mind having 14 entries in those date
ranges, even if some of the days werent worked, as I can always run a query
later to delete the records without the manually entered data. Any help
would be greatly appreciated, even if its just to tell me that I should try
something else, point me at a link that may help me figure it out on my own.
thanks for your time.
table, based on date range, for every entry in an authorized service table.
Some information on the form need only be noted once, such as name, client
and service, while there needs entries for the 14 new records. I will note
the tables, relationships, and form set up following.
Tables:
(P+F)=(Primary to Foreign)
Staff table(P+F)Staff Assignments(F+P)Authorizations(F+P)Clients
P
F
+
+
F
P
Billing Table Service Codes
Those are the tables and to which table they are linked
Here is how I would like the form to set up
Following are 1 Entry only
(staff name, client name, service code all defined through the staff
assignment table)
Billing Period (will define dated entries for service) example is 6/9/2006
Staff Name (only need once per set of entries)
Client Name (only need once)
Service Code (only need once)
******Following Entries should have 14 per form but each being a different
record****
Date of service (derived from the billing period 14 entries auto fill)
Example 5/27/06 5/28/06 5/29/06----all the way up to billing
period 6/9/06
Time of service (manual entry for each date of service)
Billing Status (y/n entry for each date)
Signed form (y/n for each date)
Signed Note (y/n for each date)
Units billed (manual entry for each date of service)
Is there a way to set this up? I dont mind having 14 entries in those date
ranges, even if some of the days werent worked, as I can always run a query
later to delete the records without the manually entered data. Any help
would be greatly appreciated, even if its just to tell me that I should try
something else, point me at a link that may help me figure it out on my own.
thanks for your time.