[AccessD] A little help, please

jwcolby jwcolby at colbyconsulting.com
Mon Mar 30 11:42:58 CDT 2009


That certainly helps the programmer decide if something needed editing, but it does not solve the 
"bound to a FK" issue.  If the two tables have different data but the same values for a PK, AND you 
are binding the PK to an FK in the currently displayed table, then you have a problem.

I was assuming that one table was dynamic and the other was static - imported data or something like 
that.

John W. Colby
www.ColbyConsulting.com


Susan Harkins wrote:
> 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



More information about the AccessD mailing list