Changing the contents of one field based on what is entered in another field

[jim0203]

Say I have a database with three tables, Cats, Vets, and Operations:

Cats:

Name (PK)

Breed

Color

Vets:

Name (PK)

Age

Operations:

Performed by (can only be one of Vets::Name)

Performed on (can only be one of Cats::Name)

Age of Vet

Color of Cat

I want to enter "performed by" and "performed on" into the Operations table, and have "age of vet" and "color of cat" filled in automatically for me. Simple, I know, but I can't work out how to do it!

[RalphL]

See the sample file posted here: http://fmforums.com/forum/showtopic.php?tid/200977/post/317476/fromactivity/myposts/#317476

Add CatID and VetID and use those as your primary keys. Name is a bad choice for a key field.

[jim0203]

That's great, thank you. I'm still a FM noob but I finally feel that I'm getting somewhere, mainly because of the help I'm getting on this forum!