RE: [MS_AccessPros] Union Query -- redesign

Bill,
You typically bind (set the control source) to the "ID" fields. You can set this column to a width of 0" so it doesn't display.

Duane Hookom
MS Access MVP

To: MS_Access_Professionals@yahoogroups.com
From: Bill.Singer@at-group.net
Date: Thu, 1 Dec 2011 14:37:26 -0600
Subject: RE: [MS_AccessPros] Union Query -- redesign

I have split my database into the approiate amount of tables

t_Customers
CustID
Customer

t_InsTyp
InsTypID
InsuranceTyp

t_Carriers
CarrierID
InsuranceCarrier

Now I Want to populate a table with records.

t_GroupSetUp

CustID
InsTypID
CarrierID

I believe the objective is to use the ID numbers and not the Names. For
example I believe I should store the value "1" in CarrierID field and not
the name "Dearborn National". I would like to use Combo Boxes on a form to
populate the field so that carriers are chosen from a list...from t_Carrier.

Is is possible to have a Combo Box show the name "Dearborn National" in the
Box but store the value "6" in my CarierID field in the t_GroupSetup.

I cannot get it to work. Maybe I have this wrong and I should store the
actual name in the table field. I could get that to work, I think.

Thanks,
Bill
MN

Bill Singer

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

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

Yahoo! Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/MS_Access_Professionals/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/MS_Access_Professionals/join
(Yahoo! ID required)

<*> To change settings via email:
MS_Access_Professionals-digest@yahoogroups.com
MS_Access_Professionals-fullfeatured@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
MS_Access_Professionals-unsubscribe@yahoogroups.com

<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/