Organizer Deluxe & Organizer Pro Help Center

Topic #:ID-1088

Ask a question, report problem, ..
    
Database Management FAQ : Database Fields : Table Field

Related software (Read/Download) :
Small Library Organizer Pro
   Question/Topic:
How to add a new specialized table field?

Similar questions:

  1. Does your database solution allow attachments? When our pack slips and invoices come, in relation to the purchase order, we scan and save them. We would like to attach them to the purchase order in a data base of purchase orders.?


The sample database has only three database fields: Title (title of the group of documents), Date (entry date), Notes (notes about group of documents). I will add a new field that will allow me to store links to documents (attachments).

database sample

Add new specialized table field (attachment field):

  1. Start Organizer Deluxe
  2. On the File menu, click Designer.
  3. In the Designer window click Modify Database.
  4. In the Select Database window select database name in the Available Databases box (this database will be modified). Click OK.
  5. In the Modify Database window click New Field.
  6. Enter your field name into Field Name box, select Memo in the Field Type drop down box. Click OK.
    create table field
  7. In the Modify Database window click Save. Field Layout Designer is displayed.
  8. In the Field Layout Designer window click Add Page button to add new data display page. You can enter your name for the data display page in the Page Name box. (e.g.: Attachments)
  9. In the Database Fields there is your new field (e.g.: ATTACHMENT), click on the field so the radio box in front of the field changes to a check mode.
  10. In the Data Entry Control window select Table, click OK.
    table field control
  11. Table field is inserted into Attachment data display page.
    table, attachment data field
  12. Click OK.
  13. In the Designer click Organizer Deluxe.
  14. Your database is modified and has the new Table (Attachment) field.
    database with new table field
  15. Click with right mouse button on the field and select Edit Table Field from the popup menu.
  16. Click Edit Headers in the Edit Table Field window. Delete the value displayed and enter title. Click Add Column and enter document as a new column name (for storing attachments). Click OK to close the window.
    Edit table Field window, define columns, column names..
  17. Table field is ready for storing document titles and links. Click with the right mouse button on the document column and select Insert File Attachment. Select the document on your computer and click Open. The link is automatically inserted into the table field. Double click on the link will launch the file with its associated application.
    table/attachment field sample entries

Warning:
Your previous backup file will no longer be compatible with your restructured database. Before you add a new database field make sure your database is up-to-date and not corrupted.
All Record Templates will be lost.

  

Related Topics ...
How to add a new web address field?
How to add a new image field?
How to build database?



Related software (Read/Download) :
Small Library Organizer Pro







Copyright © PrimaSoft PC, Inc. All rights reserved.