[AccessD] A little help, please

You can IF the PK is not an autonumber type of entity, IOW IF the PK is the value itself.  If it is 
an autonumber, then the two tables would each have their own PKs which might (will eventually) collide.

Also of course the combo could be bound to a field where there is no referential integrity, i.e. the 
value is just being placed into a text field (for example).

If you are trying to accomplish the "typical" combo bound to a FK in a table, then a UNION is 
dubious at best.

John W. Colby
www.ColbyConsulting.com


Mark A Matte wrote:
> Susan,
>  
>> Donna, as a rule, a combo box populated with a UNION isn't bound.
>  
> Why can't you use a UNION as a rowsource to a Bound combo box?
>  
> ...or did I misunderstand your post?
>  
> I understand the second part about updating the source tables of the combo with a function.
>  
> Thanks,
>  
> Mark A. Matte
> 
> ----------------------------------------
>> From: ssharkins at gmail.com
>>
>> Donna, as a rule, a combo box populated with a UNION isn't bound. That means
>> you'll have to call a function that updates the appropriate table, using ADO
>> or SQL, your choice really. Do you need help passing the value or what?
>>
>> Susan H.
>>
>>
>>> Hi guys!
>>>
>>> I really am stumped on this one, and could use a little help...
>>>
>>> I am trying to combine two tables using a UNION query that come from
>>> different databases. This appears to be no problem. I will be using this
>>> in a combo-box. My problem comes when Not in List happens, as I will need
>>> to add rows to only one of these tables. I'm having difficulty getting to
>>> the right database table, adding it to the combo-box, and getting back to
>>> the form. This is probably way simple, but I'm having a major brain
>>> burp...
> _________________________________________________________________
> Express your personality in color! Preview and select themes for Hotmail®.
> http://www.windowslive-hotmail.com/LearnMore/personalize.aspx?ocid=TXT_MSGTX_WL_HM_express_032009#colortheme