This will close the thread, though any comments welcome.
I solved the problem without using a relationship.
I have seen APPS in QB that just seem to have to many table relationships, where it isn't necessary to have, though they can be used. It makes troubleshooting, hard, and that is what I am a troubleshooter in programming.
Now I put the two tables in Word along with the formula for the field that is circled in red.
The source is from the Community Forum URL: https://community.quickbase.com/communities/community-home/digestviewer/viewthread?GroupId=103&MessageKey=afc09eac-7e6f-4534-85f8-2258eab08f40&CommunityKey=d860b0f8-6a48-487b-b346-44c47a19a804&tab=digestviewer
Thanks to all in the thread including QBJunkie.
At school, so it may take a bit for me to respond to comments. Thanks.
