struggling to grasp the concept...

Hi,    i am attempting an access DB for a dog rescue. i have a table for people, one for dogs and one for status' (i.e. been surrendered, been fostered, been adopted). in my dog table i have FK fo...