Crystal,
Well that is not an easy fix. It will take a while to get my brain around
how to relate all of these tables to the main customer.
Currently I have one table with columns for each of the following, plus more
CustomerName
HealthCarrier
HealthCommission
DentalCarrier
DentalCommission
LifeCarrier
LifeCommission
Etc.
It sounds like I have designed my database incorrectly. (it is like an
excel spreadsheet) It is a good thing I am not under a deadline.
I will start making the transition to multiple tables for each piece of
information and see how far I get before I get stuck. It might take me a
while to get it figured out.and then I will wake up at 3:00 in the morning
and will not be able to sleep.
I do not understand what FK=Foreign Key means or how you are suggesting I
use it.
Thanks very much,
Bill Singer
MN
From: MS_Access_Professionals@yahoogroups.com
[mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of Crystal
Sent: Sunday, November 27, 2011 8:04 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: 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 <mailto:Bill.Singer%40at-group.net> "
<Bill.Singer@at-group.net <mailto:Bill.Singer%40at-group.net> >
To: MS_Access_Professionals@yahoogroups.com
<mailto:MS_Access_Professionals%40yahoogroups.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]
_____
No virus found in this message.
Checked by AVG - www.avg.com
Version: 2012.0.1873 / Virus Database: 2101/4634 - Release Date: 11/23/11
[Non-text portions of this message have been removed]
Tidak ada komentar:
Posting Komentar