If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
2 Column Combo Box
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
|
|||
|
|||
2 Column Combo Box
=?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 | |
Display Modes | |
|
|
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 |