Thanks for the feedback. What I would be looking for in the application would be:
1. Have the ability to add, edit, delete a master record with patient profile information.
2. Have the ability to key in before & after blood sugar numbers along with medications and comments taken for breakfast, lunch and dinner. Maybe leave some optional fields for supplemental checks during the day or night.
3, Have the ability to print pre-designed reports that could be printed out to bring to your doctor.
4. Use the data entered calculate an A1C (3 month average).
5. Wish List: store food list along with the carbohydrates, fiber, sugars, and serving size.
6. Wish List: create a table that would store a list of all available diabetic medications.
Since quite a few of us diabetics have eye problems the forms, queries and reports would need to use larger fonts.
The application would be a work in progress making changes as necessary from feedback from the users.
Some of the tables I envision would be:
A main table to store personnel information i.e. name, address, phone number, doctors name, primary contact in case of emergency.
A medications table to store a list of all current diabetic medications that could be selected via a pull down list.
A transaction table. This table will store records being added. This table would store all data from data entered via an Addition form. This form would be used to enter transaction data i.e. daily blood sugar numbers with date and time taken, any medications given before or after meals, any free form comments found pertinent to the entry,
A journal table used to store any changes to the transaction table. this table will be used to do historical reporting.
A "wish list" table would be a table to store food information. i.e. food type, serving size, carbohydrates, fiber, fat, sugars.
Any assistance would be highly appreciated. As I mentioned once developed it would be placed in the public domain so any diabetic can download it for free. Via comments from the users any enhancements or bugs can be addressed.
If It would help I could create a skeleton application to give us a starting point. It would not be functional but what I would envision the forms, tables and reports would look like.
Thanks again,
Doc