Multiple data entry query

[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

 

[[MVP] S. Clark]

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
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-

 

[John Vinson]

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

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

ummmm...

WHY?

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