Search results

I am working on a insurance database. I have 4 tables 1. policy_details table with Payment Type such as Annual, Qtr, Semi Annual etc. 2. policy Payment table with details about payment such as amount, date of payment etc 3. policy Categories table which defines the types 1- Annual, 3-Atr, 5 for...

Hi, I am working on a insurance database. When changes are made to key fields such as policy start and end date, premium amount, I want the changes to be stored in a seperate field in the same table or have the old data to be saved to a new table before the changes take effect. This is so that...

Also, can you help with renew option for the policy. The policy number is unique and I am not sure how the auto renewal will work. I am assuming that there should be yes/no button for auto renewal and when the button is clicked, the existing policy should be copied as a new policy. What about...

I kind of figured that is what I needed and was half way through it. Also, can you help with renew option for the policy. The policy number is unique and I am not sure how the auto renewal will work. I am assuming that there should be yes/no button for auto renewal and when the button is...

Hi Thanks for all the help. This what I have so far Tables - Company Details, Broker details, Business Entity (Different businesses within the company have their own identification, Policy Categories for the limits like per accident, per occurence Policy Claim Categories such as Claims...

Thanks. Got it Regards Geetha

Thanks for the reply. Can you give me a example of the fields that I would need if I were to set this up as table thanks Regards

I am working in a Insurance database with policy details, premium Amount and start and end date I have a table with payment categories as Annual, Semi Annual, Quarterly (Equal), Quarterly (Other) etc When the payment is sent out, if the policy is Annual, the payment should be divided by 12...

I have rephrased the question. Can some one help "Table1 - Policy Type Table - Policy Type No and Policy Type name (1 - General, 2 - Automobile) Table 2 - Policy Type Sub Table - Policy Type No, Policy Type Sub Type (General -Aggregate Limits, General - Excess Liability, General - Sabotage...

Hi Let me explain a little more. Table1 - Policy Type Table - Policy Type No and Policy Type name (1 - General, 2 - Automobile) Table 2 - Policy Type Sub Table - Policy Type No, Policy Type Sub Type (General -Aggregate Limits, General - Excess Liability, General - Sabotage) The Policy...

Hi I have two tables - Policy Details and Policy limits Details with one to many relationship between policy details ans policy limits. I have created a form with policy details as main form and policy limits details as sub form. I have a combo box in policy limits details sub form that shows...

I have a calculated field that sums up three other fields. The calculated field should show total = 100.00 However, it shows only 100. Is there a way to fix this. I have selected standard with two decimals and also tried using format (... "#.##) Please help Regards

Thanks. Can you please tell me the code for this. I am a beginner and I am still trying to figure this out Regards

I have a form with three entries. I am creating a calculated field with the sum of these three entries. The calculated field sum should add up to 100. If not, there should be a error message that pops up and the user would not be able to proceed until the three entries are adding up to 100. How...