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

__._,_.___

Reply to sender | Reply to group | Reply via web post | Start a New Topic

Messages in this topic (23)

Recent Activity:

• New Members 8
• New Files 2

Visit Your Group

MARKETPLACE

Stay on top of your group activity without leaving the page you're on - Get the Yahoo! Toolbar now.

Switch to: Text-Only, Daily Digest • Unsubscribe • Terms of Use

.

__,_._,___