M
Mike
I'm keeping a pharmacy record for clients in which all prescriptions written
for each client are displayed based on their client number (the primary key).
The form is set up and working well enough; it's just a little unweildy.
I'd like to be able to do the following.
If there is an entry in [Refills] I'd like for Access to automatically
populate and group additional records. For example, if there are 3 refills,
Access would create 3 additional records with a descending # of refills and
group them together such that when the prescription arrives and the
prescription number is recorded, that field would automatically be filled in
for every record in the group.
I'd also like be able to sort the records by the [Rx #] field, and then by
the [Refills] field, but I can't seem to figure out how to sort the records
by more than one field. I mean, Excel is one thing, but even in Access
queries I haven't been able to designate the order of the fields by which the
records would be sorted.
Also if the prescription is discontinued, I'd like for the remaining records
in the group to be automatically deleted and to be able to highlight the
group and sort it such that it goes to the bottom of the list. I'm thinking
that the highlighting would involve conditional formatting, but I haven't yet
figured out how to conditionally format an entire record based on the value
of one field in that record. Any ideas?
Thanks,
Mike
for each client are displayed based on their client number (the primary key).
The form is set up and working well enough; it's just a little unweildy.
I'd like to be able to do the following.
If there is an entry in [Refills] I'd like for Access to automatically
populate and group additional records. For example, if there are 3 refills,
Access would create 3 additional records with a descending # of refills and
group them together such that when the prescription arrives and the
prescription number is recorded, that field would automatically be filled in
for every record in the group.
I'd also like be able to sort the records by the [Rx #] field, and then by
the [Refills] field, but I can't seem to figure out how to sort the records
by more than one field. I mean, Excel is one thing, but even in Access
queries I haven't been able to designate the order of the fields by which the
records would be sorted.
Also if the prescription is discontinued, I'd like for the remaining records
in the group to be automatically deleted and to be able to highlight the
group and sort it such that it goes to the bottom of the list. I'm thinking
that the highlighting would involve conditional formatting, but I haven't yet
figured out how to conditionally format an entire record based on the value
of one field in that record. Any ideas?
Thanks,
Mike