picture on form

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi All,

I am building a database to store information about skeletons found during
excavations. I was wondering if it is somehow possible to display a picture
of a skeleton in a form and add different selection boxes (true/false) for
the different bones to the drawing like you can do for websites. Does someone
have any ideas or other possibilities how I can do this??
Thanx in advance,

jurven007
 
I think you'll need to provide a bit more info on what you're trying to
do.
If you display the skeleton, and check "Tibia" (T/F)... what do you want
to happen?
Or... are you just saving the fact that a tibia is present?
 
Well, I'm no skeleton guru, but since there are 206 bones in the human
body, I'd seriously consider a table (tblBones) associated to each skeleton
(tblSkeleton) in a One to Many relationship.
Skeleton is the One on the main form, and Bones are the Many in a
subform.

The main form would contain the "One" info on the skeleton, Height, Sex,
Location, Age, etc. Each skeleton would also have a unique key field
identifier like a SkeletonID.

TblBones would also have a SkeletonID, and allow you to enter bone
information. I'd have a field like MajorStructure with combo values like
Cranium, Torso, Extremities, Spine... etc. That combo would narrow down the
next combo choice of the specific bone itself... Tibia, Scapula, etc...

I'll leave the rest for you to "flesh" out... Ouch!! Sorry, I couldn't
resist that... :-D
 
Hi Al,

I already created several fields (true/flase) for the bones and now I would
like to connect them to a picture of a skeleton. The idea is when I click on
the Tibia something should happen to that part of the picture so that you
know it is selected.
I thought it would be easy to cut the picture into several parts and put the
parts on buttons. This seems to work but it looks awful. Do you have any
suggestions?
Thanx,

Jurven007
 
Jurven,
Well, keeping track of the bones present on a skeleton, and any data
associated with that particular bone, is a good candidate for a database
application, but... what you want to do may really require another vehicle.
What you want to do is more of a graphic application than it a data
application, and Access would probably not lend itself easily to such a
task.
 
Back
Top