Filtering Multiple Rows based on Single Value in another table

[drallam]

HI,

I have two tables, contianing ID#'s.

Table A has a certain fixed Unique set of ID #'s.

Table B has multiple rows of each ID# meaning multiple recordings. 

I'm trying to select the ID# from Table A and show the multiple rows in Table B associated to that #. The relationships is not working. Is Measure option the way to go?

[gooranga1]

Hi @drallam,

When you say the join isn't working did you get an error message when you attempted to join? If so are both ID's set to the same data type?

If they are joined ok and are the same data type is that data type Whole Number or Text?