Hello!
I have not had much experience with different methods of design in Alpha, I have simply done the quickest and easiest way for what I needed at the time with little exploration. Here is what I have. I am designing a DB for a landscape company for a friend of mine, and the invoicing, customers, and basic business stuff is easy, and already finished. What I'm not sure of is this. They have Frequency Sheets for all of their properties. These sheets consist of a column on the left side of all the services they offer, such as Mowing, edging, supervisor visits, insect, disease control, litter, weeding, fertilizing etc... and a row above that that lists the 12 months of the year. now, going across the table, they fill in the number of times each month they go out to do whatever at the property. Services on the left (column), and months on top (row). Now, he wants to be able to input all of these whenever he gets a new property, or at the beginning of the year when he gets the new ones from the property management company. He also wants to be able to print out different reports, such as a single month with all of the properties listed across the top instead of the months, or a single year for a single property etc...
My question sis this: What would be the most efficient way to store and sort all this data? Would it be to have a set, called Frequency with 12 tables, one for each month, and linked via the property name and the year, or is there another way that I'm not thinking of? any help or examples would be appreciated. I'm trying to make this as idiot proof as possible, with the least amount of potential trouble. Thanks!
Jason
I have not had much experience with different methods of design in Alpha, I have simply done the quickest and easiest way for what I needed at the time with little exploration. Here is what I have. I am designing a DB for a landscape company for a friend of mine, and the invoicing, customers, and basic business stuff is easy, and already finished. What I'm not sure of is this. They have Frequency Sheets for all of their properties. These sheets consist of a column on the left side of all the services they offer, such as Mowing, edging, supervisor visits, insect, disease control, litter, weeding, fertilizing etc... and a row above that that lists the 12 months of the year. now, going across the table, they fill in the number of times each month they go out to do whatever at the property. Services on the left (column), and months on top (row). Now, he wants to be able to input all of these whenever he gets a new property, or at the beginning of the year when he gets the new ones from the property management company. He also wants to be able to print out different reports, such as a single month with all of the properties listed across the top instead of the months, or a single year for a single property etc...
My question sis this: What would be the most efficient way to store and sort all this data? Would it be to have a set, called Frequency with 12 tables, one for each month, and linked via the property name and the year, or is there another way that I'm not thinking of? any help or examples would be appreciated. I'm trying to make this as idiot proof as possible, with the least amount of potential trouble. Thanks!
Jason
Comment