Relationship works in portal but not in value list

[daveinc]

Hi,

I am trying to create a value list based on related values. I am using 2 concatenated text fields in the same table for either side of the realtionship. On the left, I have GetAsText(Date) & "_" & GetAsText(ID)& "_1". On the right, I have GetAsText(Date) & "_" & GetAsText(ID)& "_" & FirstRecord where FirstRecord always equals 1 if it has a value. I can see the records listed in a portal on the layout when on any record with the correct Date and ID, but they only show up in the value list when I am on one of the records that has a value of 1 in FirstRecord. I have used these types of relationships for value lists thousands of times in FM6 or earlier and never had an issue. What am I doing wrong?

[daveinc]

Duh! Figured it out. Had the table/relationship backwards. It still doesn't make sense to me in the Value List dialog, but it works now so I'll have to deal with it.