harrywils
asked on
MS Access 2007 Quering Multivalue field in a linked Table wriiten in IBM Universe
I have linked a Product Master Table written in IBM/Universe using Universe/ODBC. I am able to perform lots of queries and forms in MS ACCESS . The linked table has a field called UM (Units of Measure) and the UM field has mutivalue fields stored as shown below.
CS 1
EA 16
The first and second lines are not consistently in the same order, because of selling practice. MS Access when queried for the field containing multivalue looks only for the first line. However in the native Universe database, retrieve (aka query) shows the results like this
PMID UM F64
40021 CS 1
EA 16
As you observe PMID does not get repeated for EA.
I am looking to see the query results like this
PMID UM F64
40021 CS 1
40021 EA 16
40023 EA 9
40023 CS 1
Any help is very much appreciated.
CS 1
EA 16
The first and second lines are not consistently in the same order, because of selling practice. MS Access when queried for the field containing multivalue looks only for the first line. However in the native Universe database, retrieve (aka query) shows the results like this
PMID UM F64
40021 CS 1
EA 16
As you observe PMID does not get repeated for EA.
I am looking to see the query results like this
PMID UM F64
40021 CS 1
40021 EA 16
40023 EA 9
40023 CS 1
Any help is very much appreciated.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.