Unique Fields

Posted on 2014-12-08
Medium Priority
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??
Question by:Jass Saini
  • 3
  • 2
LVL 120

Accepted Solution

Rey Obrero (Capricorn1) earned 1000 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
LVL 18

Expert Comment

ID: 40487827
Please expand a bit on your description of the problem.

You can either use a select distinct * from source
select * from source1
select * from source2

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??
Easily Design & Build Your Next Website

Squarespace’s all-in-one platform gives you everything you need to express yourself creatively online, whether it is with a domain, website, or online store. Get started with your free trial today, and when ready, take 10% off your first purchase with offer code 'EXPERTS'.

LVL 18

Assisted Solution

Simon earned 1000 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?

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.

Author Closing Comment

by:Jass Saini
ID: 40487926

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

This article shows how to get a list of available printers for display in a drop-down list, and then to use the selected printer to print an Access report or a Word document filled with Access data, using different syntax as needed for working with …
What to do if a split doesn't fit? Or a bunch of invoice lines must be rounded while the sum must match a total? It takes a little, but - when done - it is extremely easy to implement.
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …

624 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