Concatenating first 3 records then stops

[crobaseball]

I'm trying to concatenate several fields from a set of tables/subtables. But for some reason, it concatenates the first 3 records, then stops. I should clarify that the concatenation "skips" a subtable. Here's the structure of the relationships (not sure if this pic is working so I'm adding the link to the screen shot)



http://www.pixentral.com/show.php?picture=1GoriwfI6lz8yNdnJ7eTr7SOUVrN

and the concatenation itself

As you can see, I'm looking to create a concatenation of (Vendor_Code)&(Vendor_Item_Code)&(Item_ID) which runs through the subtable Items_Child, but doesn't use any field in Items_Child

What am I missing here?

[June7]

Table List_of_sources_for_it... appears to be incorrectly linked. Should it link to Location_ID instead?

[crobaseball]

Yes that was the case . . . but the underlying problem: I somehow set the Location_ID as a text field instead of a number field. Feeling rather foolish. It happens :-)