Alpha DevCon 2018
Results 1 to 8 of 8

Thread: Designing a Receipting System

  1. #1
    Member
    Real Name
    Boom Boy
    Join Date
    May 2016
    Location
    South Africa
    Posts
    5

    Default Designing a Receipting System

    Good Day All

    Please may I have some assistance.

    Please NOTE that I don't really know much about SQL and Programming.
    I am currently trying to design a RECEIPTING SYSTEM for an INSURANCE Database.
    I have MEMBERSHIP (Parent) Table and a RECEIPTS (CHILD) table with the Primary Key being POLICY NO.
    When the Policy No is ENTERED in to the FORM of the RECEIPTS Table, The SURNAME AND NAME is populated from the MEMBERSHIP Table.

    REQUIRED

    1. The System need to check for the Date of Last Payment and Month Paid for.
    2. The System then needs to Increment the MONTH on the NEW RECEIPT, taking into account the change in YEAR should it be (DEC to JAN).

    Please ADVISE whether addition Tables are REQUIRED.

    Any Assistance would be Highly Appreciated.

    Kind Regards
    Verulam

  2. #2
    "Certified" Alphaholic DaveM's Avatar
    Real Name
    Dave Mason
    Join Date
    Jul 2000
    Location
    Hudson, FL
    Posts
    5,919

    Default Re: Designing a Receipting System

    What version of alpha?
    web or desktop?
    Generally, one posts accordingly.
    Dave Mason
    dave@aldaweb.com

    Skype is dave.mason46

  3. #3
    Member
    Real Name
    Boom Boy
    Join Date
    May 2016
    Location
    South Africa
    Posts
    5

    Default Re: Designing a Receipting System

    Hello Dave


    Thank You for the reply

    I am using Alpha Five version 10.5 Desktop

    Regards
    Verulam
    Last edited by verulam; 05-05-2016 at 08:59 AM.

  4. #4
    "Certified" Alphaholic DaveM's Avatar
    Real Name
    Dave Mason
    Join Date
    Jul 2000
    Location
    Hudson, FL
    Posts
    5,919

    Default Re: Designing a Receipting System

    May I suggest you post in that part of the forum? More people will see it and you may get much more help.
    I don't use sql on desktop, but others do.
    Dave Mason
    dave@aldaweb.com

    Skype is dave.mason46

  5. #5
    Member
    Real Name
    Boom Boy
    Join Date
    May 2016
    Location
    South Africa
    Posts
    5

    Default Re: Designing a Receipting System

    thank You Dave

    I am new to this s....not sure which part to post to.....

    Kind Regards
    Verulam

  6. #6
    Member
    Real Name
    Boom Boy
    Join Date
    May 2016
    Location
    South Africa
    Posts
    5

    Default Designing a Receipting Database for Desktop

    Good Day All

    Please may I have some assistance.

    Designing a Receipting Database for Desktop with Alpha Five ver10/11

    Please NOTE that I don't really know much about SQL and Programming.

    I am currently trying to design a RECEIPTING SYSTEM for an INSURANCE Database.
    I have MEMBERSHIP (Parent) Table and a RECEIPTS (CHILD) table with the Primary Key being POLICY NO.
    When the Policy No is ENTERED in to the FORM of the RECEIPTS Table, The SURNAME AND NAME is populated from the MEMBERSHIP Table.

    REQUIRED

    1. The System need to check for the Date of Last Payment and Month Paid for.
    2. The System then needs to Increment the MONTH on the NEW RECEIPT, taking into account the change in YEAR should it be (DEC to JAN).

    Please ADVISE whether addition Tables are REQUIRED.

    Any Assistance would be Highly Appreciated.

    Kind Regards
    Verulam

  7. #7
    "Certified" Alphaholic
    Real Name
    Tom Cone Jr
    Join Date
    Apr 2000
    Location
    Florida
    Posts
    23,300

    Default Re: Designing a Receipting Database for Desktop

    Dear Boom,

    Native Alpha Five tables are Foxpro DBF's, not SQL.

    If your Receipts table contains the date of last payment and month paid for, you probably don't need other tables.

    One approach that gives you more flexibility than using table field rules would be to put a button on your form the user must push to enter a new payment record. That button would run a script that prompts the user for the policy number, looks up the last payment info, enters a new record and populates the policy number, date of last payment and Month fields.

  8. #8
    Member
    Real Name
    Boom Boy
    Join Date
    May 2016
    Location
    South Africa
    Posts
    5

    Default Re: Designing a Receipting Database for Desktop

    Hi Tom

    Trust that you are well and Thank You for replying.

    I am new at it and not sure how to do scripts

    1. How would I go about writing a script for he Button.
    2. I also need for the Month to be incremented on the Current Record of payment taking into account the change in YEAR should it be January of the next
    year.

    Thanking You & Kind Regards
    Boom

Similar Threads

  1. Replies: 3
    Last Post: 06-08-2009, 09:26 PM
  2. Help with designing report
    By jdoyle in forum Alpha Five Version 8
    Replies: 11
    Last Post: 03-19-2007, 09:18 AM
  3. Need help designing set
    By BRIAN GRAY in forum Alpha Five Version 5
    Replies: 7
    Last Post: 07-27-2004, 10:02 AM
  4. Database Designing
    By Wexler in forum Alpha Five Version 5
    Replies: 5
    Last Post: 03-18-2004, 01:01 AM
  5. Designing A5 while still using 4.5
    By Tony Watts in forum Alpha Five Version 5
    Replies: 2
    Last Post: 08-04-2002, 08:41 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •