Multiple data entry query

  • Thread starter Thread starter Rob Latchford
  • Start date Start date
R

Rob Latchford

Hi

Can anyone assist me with a query that I am trying to do
within access. I have one table with data in it with a
unique key (value a) and then another table with that key
(value a) is duplicated in most instances. In this second
table value a is duplicated in most instances with another
value (value b).

What I need to do is match the tables together but get all
the values in the second table, value b into the first
table. This is an example of that data below

Table 1

Value a XXXXSD49566


Table 2

Value a XXXXSD49566
Value b IA6
Value a XXXXSD49566
Value b QAC
Value a XXXXSD49566
Value b R1K

What I would like to see in table 1 is the following

Value a XXXXSD49566
Value b1 IA6
Value b2 QAC
value b3 QAH

If anyone has any suggestions or can tell me how to do
this I'd appreciate it

Thanks
 
In order to "See" this in table 1, would require changing the structure of
it to be something like:
ID
Val1
Val2
Val3

What if an ID has 100 matching values?

This is not really what a database is designed to do. What you can do is
display the Parent Value (XXXXSD49566) in a form or report, then in a
SUBform or SUBreport, display each of the matching child values.

--
HTH,

Steve Clark, Access MVP
FMS, Inc.
Professional Solutions Group
http://www.FMSInc.com
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Is your Access database too slow?
Are you ready to upgrade to SQL Server?
Contact us for optimization and/or upsizing!
http://www.FMSInc.com/consulting
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
 
What I would like to see in table 1 is the following

Value a XXXXSD49566
Value b1 IA6
Value b2 QAC
value b3 QAH
Click to expand...

ummmm...

WHY?

That would be storing data redundantly. Why not just create a Query
joining Table1 and Table2 on the first field?
 
Back
Top