Alpha Video Training
Results 1 to 3 of 3

Thread: Database Relation Structure Help

  1. #1
    Member
    Real Name
    Bob M
    Join Date
    Dec 2001
    Posts
    560

    Default Database Relation Structure Help

    Sorry. Posted this in wrong location earlier.
    =========================
    Each customer type will have policies from different companies. Every company offers a variety of policy types and each policy is assigned a unique and lasting policy number.

    A policy can renew every 6 or 12 months with a premium change when it renews. In addition, during the 6 or 12 month policy period a policy can be changed, thus raising or lowering the premium. I want to be able to track that and see the premium change effect on screen.

    Once a policy number is assigned to a customer, that policy number remains with the customer in my database whether the customer stays active or departs.

    When the policy period ends (renews) the policy number remains the same but the premium changes. I want to not only change a policy from active to expired but also want to see the policy premium from previous policy periods, even though they have expired or were canceled.

    In addition, I want to be able to link stored policy documents (which I have the code for provided through an earlier discussion on this board) to a specific policy period. Hence a policy renews and documents for that specific period would show only for that policy period.

    Suggestions are, in advance, greatly appreciated. If I have you confused please ask a question (or 2, or 3, or 4).

    Thanks

  2. #2
    "Certified" Alphaholic
    Real Name
    Gregg Schmidt
    Join Date
    Mar 2001
    Location
    Milwaukee
    Posts
    1,243

    Default Re: Database Relation Structure Help

    This sounds similar to me keeping track of prices for various services for various customers.
    I keep a rate table that includes the customer id, service, cost, begin date, and end date.
    I also include a recID just in case I somehow get duplicates.

  3. #3
    Member
    Real Name
    angela chan
    Join Date
    Feb 2019
    Posts
    1

    Default Re: Database Relation Structure Help

    That's a good idea

Similar Threads

  1. Database Structure
    By glazier in forum Application Server Version 11 - Web/Browser Applications
    Replies: 10
    Last Post: 12-03-2012, 07:56 PM
  2. How to work with a Toggle button/ button to make relation with database field?
    By Suvarchala in forum Application Server Version 11 - Web/Browser Applications
    Replies: 1
    Last Post: 01-02-2012, 06:50 AM
  3. structure database
    By SmartMLMer in forum Alpha Five Version 9 - Desktop Applications
    Replies: 3
    Last Post: 10-17-2009, 08:05 PM
  4. Need Help With Structure of Database
    By Herbert in forum Alpha Five Version 5
    Replies: 6
    Last Post: 05-19-2003, 10:41 AM
  5. Using Database Structure for Import Structure?
    By Ken Wargon in forum Alpha Five Version 4
    Replies: 9
    Last Post: 01-25-2002, 07:10 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
  •