Appointment system help

[mortisha_i_am]

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.

 

[mortisha_i_am]

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.

 

[pietlinden]

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.