[AccessD] A little help, please

I'd just populate a hidden column with the name of the source in the UNION.

Susan H.
----- Original Message ----- 
From: "jwcolby" <jwcolby at colbyconsulting.com>
To: "Access Developers discussion and problem solving" 
<accessd at databaseadvisors.com>
Sent: Monday, March 30, 2009 12:15 PM
Subject: Re: [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
-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com