[AccessD] A little help, please

Hi Jim et al

Include one field as a table ID with a value where value is 0 for the one table and 1 for the other:

Select
  *,
  0 As TableId
From
  tblTableA
Union
Select
  *,
  1 As TableId
From
  tblTableB

/gustav

>>> JHewson at nciinc.com 30-03-2009 18:14 >>>
I understand using a UNION query for the combo.
I understand that the source tables need to be updated.
What I don't understand is how to figure out which table from the UNION
that would need to be updated?
If the value entered should be in tblA, how would a function know that?

Jim


-----Original Message-----
From: accessd-bounces at databaseadvisors.com 
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Mark A Matte
Sent: Monday, March 30, 2009 11:06 AM
To: accessd at databaseadvisors.com 
Subject: Re: [AccessD] A little help, please


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