Solved

Unique Fields

Posted on 2014-12-08
6
72 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 119

Accepted Solution

by:
Rey Obrero 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
Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

 
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

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)

Question has a verified solution.

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

This article is a continuation or rather an extension from Cascading Combos (http://www.experts-exchange.com/A_5949.html) and builds on examples developed in detail there. It should be understandable alone, but I recommend reading the previous artic…
Most if not all databases provide tools to filter data; even simple mail-merge programs might offer basic filtering capabilities. This is so important that, although Access has many built-in features to help the user in this task, developers often n…
What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …

930 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

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now