ArtWork was written using HanDBase version 3 and its accompanying forms program. It is designed to track work produced by an artist. The "calculated," "linked", "relationship," and database popup" (DB popup) field types are used throughout the application. There are seven databases. This version is "release 2."
ArtWork is the primary database. It draws from each of the child databases. The "db-popup" field type is used in the "To Do" routine to draw information into it. Information captured includes item description, item #, sold to, date sold and to do. In this revision, the "item #" field was changed to "auction #."
The child databases are
ArtContacts - tracks "contact" information. Captured information includes name, address, city, state, zip phone number(s), shipping information and notes.
ArtItems - the items produced by the artist. Captured information includes the item name, item number, description, hours and hours to make, and notes. In this release, the item number was changed to "auction number" and three fields were added:
"Copy this record to new" - allows the creation of a copy of the displayed record to facilitate editing of the "new" record with emphasis to the "number of this item" and "total number released" fields. Number of this item - If multiple copies of the item are made. Total number released - tracks the total number of the item released.
ArtNotes - captures "note" information. There are three note fields to capture information.
ArtShipMethod - captures methods of shipment, such as USPS, UPS, Federal Express. Information captured includes the shipping method and notes.
ArtToDo - tracks "to do" activity. Information captured includes action, date/time to do, done (check box), time/date done, contact person, notes, cost, amount owed, running cost and running cost owed. The database is "related" using the "date created" field.
ArtToDoList - is a list of various activities the ArtToDo database pulls from.
The forms in each database are designed to allow movement between related forms and in many cases from the first, to last, and to next record.
Related information displayed within the forms is indiated by the number of "related records" in the database being draw from. Tapping on the displayed number displays the "related files." In addition, links are provided to edit/display all records in another database. It is desirable to edit a "related record" from the "parent record" in order to maintain proper indexing.
Revision history
7-1-03 - In the "ArtItems" database, added three new fields: Copy this record to new; number of this item; total number released. Also changed "item #" to "auction #."
7-1-03 - In the "ArtWorks database, changed "item 3" to "auction #."
7-1-03 - Cleaned up the forms. The device the forms were originally tested on was a bit messed up; as a result, many fields, control, et cetera, were not accurately placed or designed.
Has Data:
Yes
Has Forms:
Yes
Comments:
ArtWork was written using HanDBase version 3 and its accompanying forms program. It is designed to track work produced by an artist. The "calculated," "linked", "relationship," and database popup" (DB popup) field types are used throughout the application. There are seven databases. This version is "release 2."
ArtWork is the primary database. It draws from each of the child databases. The "db-popup" field type is used in the "To Do" routine to draw information into it. Information captured includes item description, item #, sold to, date sold and to do. In this revision, the "item #" field was changed to "auction #."
The child databases are
ArtContacts - tracks "contact" information. Captured information includes name, address, city, state, zip phone number(s), shipping information and notes.
ArtItems - the items produced by the artist. Captured information includes the item name, item number, description, hours and hours to make, and notes. In this release, the item number was changed to "auction number" and three fields were added:
"Copy this record to new" - allows the creation of a copy of the displayed record to facilitate editing of the "new" record with emphasis to the "number of this item" and "total number released" fields. Number of this item - If multiple copies of the item are made. Total number released - tracks the total number of the item released.
ArtNotes - captures "note" information. There are three note fields to capture information.
ArtShipMethod - captures methods of shipment, such as USPS, UPS, Federal Express. Information captured includes the shipping method and notes.
ArtToDo - tracks "to do" activity. Information captured includes action, date/time to do, done (check box), time/date done, contact person, notes, cost, amount owed, running cost and running cost owed. The database is "related" using the "date created" field.
ArtToDoList - is a list of various activities the ArtToDo database pulls from.
The forms in each database are designed to allow movement between related forms and in many cases from the first, to last, and to next record.
Related information displayed within the forms is indiated by the number of "related records" in the database being draw from. Tapping on the displayed number displays the "related files." In addition, links are provided to edit/display all records in another database. It is desirable to edit a "related record" from the "parent record" in order to maintain proper indexing.
Revision history
7-1-03 - In the "ArtItems" database, added three new fields: Copy this record to new; number of this item; total number released. Also changed "item #" to "auction #."
7-1-03 - In the "ArtWorks database, changed "item 3" to "auction #."
7-1-03 - Cleaned up the forms. The device the forms were originally tested on was a bit messed up; as a result, many fields, control, et cetera, were not accurately placed or designed.
Checkout Cart (11 Items)
