1 Reply Latest reply on Oct 7, 2013 6:48 PM by davidanders

    Building a Database for a dog rescue

    AdamPratter

      Title

      Building a Database for a dog rescue

      Post

           I work for a dog rescue here in San Diego. We decided to build our own database in filemaker to track the dogs medical and general info for better organization. I know beginning levels of filemaker and learning the more advanced steps but I am having trouble figuring out how to plan out the database.  My current issue is what information to place in what table. I created a table  for the general dog info like breed etc. , but I need to track their medical (vaccinations and medicine) they receive and also if they get adopted, or fostered or if they have appts to be adopted.  Should I place the medical in a different table and the movements (adoption, foster, etc) in a third table. And then just create a relationship between the tables? I figure the dogs are kinda like the customers and the medicine is like orders.  If anyone can help I would appreciate it.