Appointment system help

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

mortisha_i_am - 29 Aug 2006 14:36 GMT

Hi, i'm looking for some help with an appointment system for a local animal
sanctuary and I keep thinking it can be done with a query but I can't seem to
figure it out. My problem is this:

When I have found an animal in the database, I want to be able to add an
appointment for it from that page, but I want the details such as the Reg.
Number, Animal Name and Sex to appear on the appointment list without having
to select it in a dropdown menu (as they have so many animals it would be
impracticle). Is there a way to do this??

It's probably something really simply now and i'll feel really stupid, lol.

Reply to this Message

mortisha_i_am - 29 Aug 2006 14:57 GMT

>Hi, i'm looking for some help with an appointment system for a local animal
>sanctuary and I keep thinking it can be done with a query but I can't seem to
[quoted text clipped - 7 lines]
>
>It's probably something really simply now and i'll feel really stupid, lol.

>>>>>>>>Yup....i'm stupid. It just clicked in my head with how to do it using a form and specific data to display. >.<

Reply to this Message

pietlinden@hotmail.com - 29 Aug 2006 23:47 GMT

Animal(RegNumber(PK), PetName, Sex)

Appointment(ApptStart, ApptEnd, VetID, PetRegID(FK)....)

you can include other info in your Pet combobox (like RegNumber,
PetName, sex...) and set the width of those columns to zero on your
combobox. Then you can have a bunch of unbound fields in your form and
set the controlsource to

=Me!cboAnimal.Columns(0)

Note that the columns collection is zero-based, (one less than ordinal
position), so subtract one from what would seem to be the normal
position.

Reply to this Message