Hello,
I have a database where every record is a property owned by my conservation group.
The fields include such things as property location, size, stewardship plans, taxes, etc -- on each individual property.
However, for some other data, the properties are grouped: e.g., if one donor gives us three properties at the same time, we would issue one receipt, have one invoice for legal services for the whole transaction, one combined appraisal, etc -- and the grouped properties then have one asset value in our financial records.
I am unclear about the best way to organize this in the database. Obviously there are problems if each of the properties has the data since any report would be "double counting" expenses, etc.
I was thinking perhaps designating one of the properties as a "spokes-property" for the combined information, and some reports could be on that subset. But I need a way to link each property to it's group and o inspect the relevant information for each of the properties.
And there may be issues here that I haven't anticipated.
Any suggestions and feedback would be appreciated! Thanks.