ACCESS FEED: Re: [MS_AccessPros] Union Query

Minggu, 27 November 2011

Re: [MS_AccessPros] Union Query

Hi Bill,

you should only be storing insurance carrier in one field. Make a related table to store details of each type of insurance. For instance:

Carriers
- CarrierID, autonumber -- PK
- CarrierName, text

InsTypes
- InsTypID, autonumber -- PK
- InsType, text (ie: Life Insurance, Short Term Disability Insurance, Long Term Disability Insurance, Dental Insurance)

Customers
-CustID, autonumber -- PK
- etc

Policies
- PolicyID, autonumber - PK
- InsTypID, long -- FK to InsTypes
- CustID, long -- FK to Customers
- CarrierID, long -- FK to Carriers
- etc

PK = Primary Key
FK = Foreign Key

Warm Regards,
Crystal

http://www.YouTube.com/LearnAccessByCrystal

*
(: have an awesome day :)
*

________________________________
From: "Bill.Singer@at-group.net" <Bill.Singer@at-group.net>
To: MS_Access_Professionals@yahoogroups.com
Sent: Sunday, November 27, 2011 5:32 PM
Subject: [MS_AccessPros] Union Query

I have found that a UNION Query will allow me to see all 6 pieces of information from six different colums of information in one place. I have an insurance carrier that writes Life Insurance, Short Term Disability Insurance, Long Term Disability Insurance and Dental Insurance. I have the Carrier Name for each of these lines of insurance stored in seperate colums of a table. I want to view them all in one form at one time and the UNION QUERY will do that just fine... except I want to be able to edit the commission information in the UNION QUERY all on one form. The UNION QUERY will not let me edit. Does anybody have any ideas how to pull all six pieces of information together and show it on one form and have the ability to edit it?

I hope my question is clear.

Thanks,
Bill in MN, where the cold means it is programming season.

[Non-text portions of this message have been removed]

------------------------------------

Yahoo! Groups Links

[Non-text portions of this message have been removed]