2 Column Combo Box

#1 July 27th, 2004, 05:18 PM

I am trying to create a 2 column combo box in my database using the lookup wizard. But I want the 2 column to act independent from themselves. If I choose something in column 2, I want that data to appear in the record. Later, if I choose something in column1, I want that data to appear. Can this be done.

Confused,
Chris

#2 July 27th, 2004, 08:08 PM

=?Utf-8?B?bG92ZWxhbmQxMTI5?=
wrote in :

I am trying to create a 2 column combo box in my database using the
lookup wizard.

Bad move. Don't use the wizard: just design the tables and make the
relationship properly.

But I want the 2 column to act independent from
themselves. If I choose something in column 2, I want that data to
appear in the record. Later, if I choose something in column1, I want
that data to appear. Can this be done.

No. When you create relationships you are actually making links between
records, not individual fields in records. I have a feeling that you may
have a Design Problem -- if you describe a bit more about what you are
aiming to achieve, we may be able to help.

B Wishes

Tim F

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Combo box lookup doesn't work when field is blank/null	Bob Richardson	General Discussion	11	July 27th, 2004 06:21 PM
Data Dependencies between Combo Boxes	Tom	Using Forms	7	June 6th, 2004 05:25 PM
Combo Box Problem	Charles	Using Forms	0	May 28th, 2004 09:15 PM
Requery Combobox	MJ	Running & Setting Up Queries	7	May 25th, 2004 11:01 AM
adding values from another worksheet by matching criteria	Frank Kabel	Worksheet Functions	2	March 16th, 2004 03:15 PM