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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
If I use Distinct then I can't update my form...I have never used a union before??
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
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.
ASKER
Thanks
You can either use a select distinct * from source
or
select * from source1
union
select * from source2