Link to home
Start Free TrialLog in
Avatar of Jass Saini
Jass Saini

asked on

Unique Fields

I am trying to get unique fields into my table...Both have ID...how do I get one table ID to populate into another???  And how will it correlate??
ASKER CERTIFIED SOLUTION
Avatar of Rey Obrero (Capricorn1)
Rey Obrero (Capricorn1)
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Please expand a bit on your description of the problem.

You can either use a select distinct * from source
or
select * from source1
union
select * from source2
Avatar of Jass Saini
Jass Saini

ASKER

If I use Distinct then I can't update my form...I have never used a union before??
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
That is what I am using in Main/Subform....and pulling the info from the query.  I did look at the link...but it will not allow me to play the demo.  I will check it out when I get home.
Thanks