String and Field concatenation from two separate tables

[rome33]

I am trying to concatenate two fields from separate tables and have them show up in a third field. but it's not working.

I have an example #1 of how I want it to look and #2 is an example of how it is not working.

What is wrong? Can anyone tell me why #2 is not working as well as #1

I am stumped and it's driving me crazy!

Are my relationships fudged or is it something else?

Thanks!!!

urlconcatenation.zip

[Lee Smith]

look at your calculation. You are using the relationship for part and the current TO where there isn't a field for tabletest_ASSETname

Lee

[rome33]

Thanks, that worked but also is causing me more problems.

Because in the actual database, the two tables are linked by assetID rather than ASSETname. When I try to add the relationship by name it blanks all the previously entered info in the portol. Is there any way to add another link without it creating another version of the table in the rrelationships or losing the information already entered?

The portol itself is having wierd problems with the last entry. When you change the version in the last entry, it changes all the rest of the entries too.

I hope this makes sense.

here is my example with the portol

urlconcatenation2.zip

[Genx]

The portol itself is having wierd problems with the last entry. When you change the version in the last entry, it changes all the rest of the entries too.

... are you sure your not imagining that bit?... when you change the version in the last one your actually adding a new record so everything shifts up, are you sure your not just imagining that all other versions get changed?... the only reason i ask is because i dont get the problem..

genx

[rome33]

you are right! I didn't see that it scrolls up. doi

now if only the relationships were right, this would work great