# Join form question **URL:** \ **Category:** How do I?\ **Created:** [August 20, 2024, 11:51pm UTC](https://www.five.org/t/join-form-question/453 "2024-08-20T23:51:25Z")\ **Posts on this page:** 2\ **Page:** 1
**Author:** ![Mel](https://avatars.discourse-cdn.com/v4/letter/m/da6949/32.png) [@Mel](https://www.five.org/u/Mel)\ **Post date:** [August 20, 2024, 11:51pm UTC](https://www.five.org/t/join-form-question/453/1 "2024-08-20T23:51:25Z")
Hi - quick question - on a join form - Right now the form shows the first field in the connected form - is it possible/how would I create a custom display in that form that would show the first field + 2 other fields in the joined form? Similar to what one would do with a lookup query, except for a joined form? I can’t quite figure out if there is a place to write a SQL query… Also, can you have multiple join forms on a single table? (I have an asset table that has multiple parts, so there are join tables for each part) one join form seems to work but when I add a second one it doesn’t. any thoughts there? I am looking to enter information on the asset and then apply the appropriate parts that are in the database to that singular asset. If there is a better way to do this, would love to know that, alternatively! thanks for any perspective! ---
**Author:** ![mark](https://yyz2.discourse-cdn.com/flex030/user_avatar/www.five.org/mark/32/300_2.png) [@mark](https://www.five.org/u/mark)\ **Post date:** [August 21, 2024, 1:54am UTC](https://www.five.org/t/join-form-question/453/2 "2024-08-21T01:54:43Z")
Hi Mel, I am presuming the join forms are sub forms under a main form in which case it should be possible to do what you want. To ensure I understand what you are trying to do would it be possible for you to send us a cut down FDF of the issue you are having with multiple join forms? I will also respond to you first question once I can see what you are trying. Send the FDF to [support@five.co](mailto:support@five.co) and we will look at it. Best regards Mark