[AccessD] A little help, please

Perhaps my entire approach is wrong.  Here's what I am trying to do:
I am trying to create a list of payees from two tables:  1) Faculty/staff info is added by HR personnel to database1.T1; Vendors and external people would be entered into database2.T2.  Only T2 would ever be updated from this source.  And yes...it is a concern that both have autonumber pk's, which I have no idea how to resolve.  FYI...a new record would require more than just the name of the vendor (e.g., phone #, etc).

I am using Access2007.

Thanks!  Donna

-----Original Message-----
From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of jwcolby
Sent: Monday, March 30, 2009 12:16 PM
To: Access Developers discussion and problem solving
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(r).
> 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

This e-mail message (including any attachments) is for the sole use of
the intended recipient(s) and may contain confidential and privileged
information.  If the reader of this message is not the intended
recipient, you are hereby notified that any dissemination, distribution
or copying of this message (including any attachments) is strictly
prohibited.

If you have received this message in error, please contact
the sender by reply e-mail message and destroy all copies of the
original message (including attachments).