Need help getting started with project
I'm new to FMP 11 and to database development in general. I'm trying to create a simple (I think) database for my small church that would track member information and keep records for weekly donations. I want to be able to enter individual donations each week and then be able to print out a year end record of giving for each member to be used for tax purposes.
I would like to know if I am on the right track in developing this database. This is what I think I will need:
1).One table to contain the demographics and identifing information for church members. This would include a field for a unique id number for each member along with fields for name, address, phone number and that sort of thing.
2). A second table for tracking weekly donations. This would contain fields for date of donation, donor id, amount of donation, type (cash or check).
3). Creation of relationships between these two tables so that individual year end reports can be printed out for each member.
It is this third crucial step that I can not understand how to do. I have created the two tables. I've tried to create a relationship based on the member Id number. But I don't know how to procede from here.
Any guidance will be greatly appreciated.