Include fields from 2 tables on single form

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • toomay0and1s
    New Member
    • Sep 2016
    • 1

    Include fields from 2 tables on single form

    OK - I'm not a programmer. What's worse, I'm an engineer so be kind. I have an Access database that includes 2 tables: 1 lists the raw data and the 2nd lists testing results. They have the exact same number of unique samples and share a sample ID. I'd like to create a form with information from both tables linked based on the ID. Is this possible? When I tried I get a error about creating duplicate entries. I understand this is almost certainly the computer's fault and not the operator but I'm willing to consider the alternative. Any help would be much appreciated.
  • Narender Sagar
    New Member
    • Jul 2011
    • 189

    #2
    I think you need to provide some more details in order to understand your situation and resolve.

    Comment

    • Oralloy
      Recognized Expert Contributor
      • Jun 2010
      • 988

      #3
      Create a stored query that has the information that you want to review, then build a form that uses the query as its data source.

      Comment

      Working...