Takeaways Problem

[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

 

[Mike Painter]

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....

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

 

[Peter Castlehouse]

care to expand, I don't know how to do that....

tia

Pete