Category Definition Conventions
All categories will have a 'Name' field, but, depending on the Category and its purpose within your system, there are a couple other fields that are useful to have, as well as a few setup conventions that should be followed.
Type Name Note +----------+---------------+---------- Name ' personKey ' REQUIRED Text ' personCfy ' Clarify Field Memo ' personVar ' Var Field
Type Name Note +----------+---------------+---------- Name ' companyKey ' REQUIRED Text ' companyCfy ' Clarify Field Memo ' companyVar ' Var Field
Type Name Note +----------+---------------+---------- Name ' calendarKey ' REQUIRED Text ' calendarCfy ' Clarify Field Memo ' calendarVar ' Var Field
Wherever possible, "Allow Duplicates" should be set to "No" on any category that can tolerate it. If that's not possible, then the category should employ the use of a Clarify field to aid the system in item management.
The significance in the naming convention used above is best noted when you begin to use drag-and-drop between the Person/Company categories and the Calendar category. The definition of drag-and-drop between categories says that any fields between to different categories that are named the same are copied from the source category to the drag-destination category. This is seriously problemmatic if the Clarify and Var fields are named identically between two categories. Furthermore, having the field names for these three fields makes them easy to remember.
~ ~ ~ ~ ~ ~
Source Code without Comments is like a Cranberry Garland
without the berries. Comment your Code!
Commence Database User Support Group Forum
~ ~ ~ ~ ~ ~
Author: Mark Petryk
Lorimark Solutions, LLC