A
Adiankur
I am developing a database that I need to be able to creat multiple records
based on a date range. What I would like to be able to do is enter a date on
a form. from that date, I would like to have 14 empty fields tagged directly
to that date and the preceeding 13 days open up. once those fields exist, a
person would type in a time range, which would then allow a billing entry to
be created on the billing table.
I do want each box that has data entered to become a seperate billing entry.
I dont want fields that have no data entered to become a billing entry.
The tables I have are an authorization table, which supplies what is actually
billable, a staff assignment table, which shows which staff are assigned to
those authorizations, and a billing table that takes each individual entry of
a billing instance.
each billing instance is a unique event based on the authorization assignment
code, Date, and time.
I would appreciate if someone would point me in the right direction, be it an
article, form topic or just some simple advice. thanks for your time
based on a date range. What I would like to be able to do is enter a date on
a form. from that date, I would like to have 14 empty fields tagged directly
to that date and the preceeding 13 days open up. once those fields exist, a
person would type in a time range, which would then allow a billing entry to
be created on the billing table.
I do want each box that has data entered to become a seperate billing entry.
I dont want fields that have no data entered to become a billing entry.
The tables I have are an authorization table, which supplies what is actually
billable, a staff assignment table, which shows which staff are assigned to
those authorizations, and a billing table that takes each individual entry of
a billing instance.
each billing instance is a unique event based on the authorization assignment
code, Date, and time.
I would appreciate if someone would point me in the right direction, be it an
article, form topic or just some simple advice. thanks for your time