Solved

Unique Fields

Posted on 2014-12-08
6
76 Views
Last Modified: 2014-12-08
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??
0
Comment
Question by:Jass Saini
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
6 Comments
 
LVL 120

Accepted Solution

by:
Rey Obrero (Capricorn1) earned 250 total points
ID: 40487826
in most cases, question like this ends up to something different that was originally asked, perhaps this will be the solution

Set the relationship between two tables
0
 
LVL 18

Expert Comment

by:Simon
ID: 40487827
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
0
 

Author Comment

by:Jass Saini
ID: 40487856
If I use Distinct then I can't update my form...I have never used a union before??
0
Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

 
LVL 18

Assisted Solution

by:Simon
Simon earned 250 total points
ID: 40487894
Ah, you didn't mention that this was for use in a form.

Consider a parent/child form (the Access form wizard can help you set one up), where you link the parent to the child on the ID column that is in both tables. If you have a main table and a second table whose records must always be linked to and ID in the main table, this is usually a good working design. Also known as main form with subform(s).

Have you looked at Rey's link on table relationships?
0
 

Author Comment

by:Jass Saini
ID: 40487924
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.
0
 

Author Closing Comment

by:Jass Saini
ID: 40487926
Thanks
0

Featured Post

Ransomware: The New Cyber Threat & How to Stop It

This infographic explains ransomware, type of malware that blocks access to your files or your systems and holds them hostage until a ransom is paid. It also examines the different types of ransomware and explains what you can do to thwart this sinister online threat.  

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

As tax season makes its return, so does the increase in cyber crime and tax refund phishing that comes with it
Preparing an email is something we should all take special care with – especially when the email is for somebody you may not know very well. The pressures of everyday working life stacked with a hectic office environment can make this a real challen…
Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…

737 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question