Takeaways Problem

  • Thread starter Thread starter Peter Castlehouse
  • Start date Start date
P

Peter Castlehouse

Bit of a dilemma here folks.

I have numerous 'customers' who attend a clinic nearly every weekday, but
hardly every on weekends. What they are dispensed is controlled by a
prescription. The script indicates that on the days they do not attend the
clinic, they shall be given a takeaway for every non-attendance-day, and
this is collected by the customer on the last day they attend. Make sense
so far?

What I need to do is create a table of records for the takeaways, so that
the dispenser knows what to dish out, and when.

I don't want the person entering the script to have to type in takeaway
values for two/three days per week, for a period which may extend to six
months! That's a considerable amount of time on data-entry.

Can anyone suggest a solution, so that when the script is initially entered,
it auto populates the takeaway table from fields on a form? I may also add
that it could be random days of the week that are selected, not just
Saturday and Sunday....

many thanks in anticipation

love this newsgroup, me....

OzPete
 
Peter Castlehouse said:
Bit of a dilemma here folks.

I have numerous 'customers' who attend a clinic nearly every weekday, but
hardly every on weekends. What they are dispensed is controlled by a
prescription. The script indicates that on the days they do not attend the
clinic, they shall be given a takeaway for every non-attendance-day, and
this is collected by the customer on the last day they attend. Make sense
so far?

What I need to do is create a table of records for the takeaways, so that
the dispenser knows what to dish out, and when.

I don't want the person entering the script to have to type in takeaway
values for two/three days per week, for a period which may extend to six
months! That's a considerable amount of time on data-entry.

Can anyone suggest a solution, so that when the script is initially entered,
it auto populates the takeaway table from fields on a form? I may also add
that it could be random days of the week that are selected, not just
Saturday and Sunday....
Click to expand...
It should be just a matter of duplicating the records with different values
for date(?) and refills or whatever you use to track the takeaways.
This can be done with a loop and INSERT INTO
 
Back
Top