Solved

Unique Fields

Posted on 2014-12-08
6
75 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
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
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

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

Suggested Solutions

Phishing attempts can come in all forms, shapes and sizes. No matter how familiar you think you are with them, always remember to take extra precaution when opening an email with attachments or links.
Access custom database properties are useful for storing miscellaneous bits of information in a format that persists through database closing and reopening.  This article shows how to create and use them.
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.
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…

763 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