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
Solved

Unique Fields

Posted on 2014-12-08
6
74 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
  • 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
U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.

 
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-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

Question has a verified solution.

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

Suggested Solutions

In the previous article, Using a Critera Form to Filter Records (http://www.experts-exchange.com/A_6069.html), the form was basically a data container storing user input, which queries and other database objects could read. The form had to remain op…
QuickBooks® has a great invoice interface that we were happy with for a while but that changed in 2001 through no fault of Intuit®. Our industry's unit names are dictated by RUS: the Rural Utilities Services division of USDA. Contracts contain un…
In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.

765 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