Extreme newbie relationship question

[beavis]

I have a pets database.

Table: Cats

Fields: Owner, Cat1, Cat2

Table: Dogs

Fields: Owner, Dog1, Dog2

I have created a relationship between the owner fields of the cats and dogs table.

I have a button on Cats layout that when clicked goes to the Dogs layout. Let's say I type "Liz" into the owner field on the cats layout and then "fluffy" and "scruffy" under Cat1 and Cat2 respectively. When I click the button, I would like the Dogs layout to show "Liz" and immediately start entering Liz' dogs. However, all I get is a blank record under dogs. How do I make this so that when I change layout from cats to dogs, the owner field in the cats table is automatically entered into the owner field in the dogs table.

I hope this makes enough sense for your help!

[Stuart Taylor]

Hi Beavis ... Welcome to the Forums :

I think you need 2 tables ... but different to the ones you have mentioned

Client (owner) & Animal

See attached...

Pets.fp7.zip