# Connection fields on form **URL:** \ **Category:** Get Answers\ **Created:** [February 5, 2024, 12:06am UTC](https://forums.knack.com/t/connection-fields-on-form/15654 "2024-02-05T00:06:04Z")\ **Posts on this page:** 9\ **Page:** 1
**Author:** ![EdCooper15510](https://avatars.discourse-cdn.com/v4/letter/e/9de053/32.png) [@EdCooper15510](https://forums.knack.com/u/EdCooper15510)\ **Post date:** [February 5, 2024, 12:06am UTC](https://forums.knack.com/t/connection-fields-on-form/15654/1 "2024-02-05T00:06:04Z")
My app has the following 2 tables that are **connected**. Organization fields… Organization Account rep Opportunities fields… Organization (dropdown from connected table Organization) * * * On the Opportunities grid I can add the Account Rep from the connected Organization table because when I go to add a column it lists all the ‘connection’ fields from Organization. However, when I try to add Account Rep to the Opportunities Add or Edit form it onlt displays fields from the Opportunities table. I need to be able to display, on the Opportunities add and edit form, the Account Rep (from the Organization table) after I select the Organization from the dropdown. Automatically fill in the Account rep field. ---
**Author:** ![CSWinnall](https://sea2.discourse-cdn.com/flex020/user_avatar/forums.knack.com/cswinnall/32/3631_2.png) [@CSWinnall](https://forums.knack.com/u/CSWinnall)\ **Post date:** [February 5, 2024, 8:46am UTC](https://forums.knack.com/t/connection-fields-on-form/15654/2 "2024-02-05T08:46:36Z")
Hi @EdCooper15510 Unfortunately you can only add or edit fields from the same object. There is no support for forms that update multiple objects. I am hoping that it is on Knacks radar. The only way you could do this now, would be to have a field in your **Oportunities** object which matches the field **Account Rep** in the connected **Organisations** object. Then, using form record rules to update a connected object, set the field in Organisations to match the field in Opportunities. Craig ---
**Author:** ![EdCooper15510](https://avatars.discourse-cdn.com/v4/letter/e/9de053/32.png) [@EdCooper15510](https://forums.knack.com/u/EdCooper15510)\ **Post date:** [February 5, 2024, 3:03pm UTC](https://forums.knack.com/t/connection-fields-on-form/15654/3 "2024-02-05T15:03:48Z")
Craig, On the add or edit form can I just have a field, Account Manager, that is display only that when a user, on the Opportunities page selects the Organization from the connected dropdown, is displays the Account Manager on the Opportunities page? This seems pretty basic and I must be missing something. Display fields on a form from a connected table. I really need this. Transitioned from QuickBase where this was able to be done. ---
**Author:** ![CSWinnall](https://sea2.discourse-cdn.com/flex020/user_avatar/forums.knack.com/cswinnall/32/3631_2.png) [@CSWinnall](https://forums.knack.com/u/CSWinnall)\ **Post date:** [February 5, 2024, 4:03pm UTC](https://forums.knack.com/t/connection-fields-on-form/15654/4 "2024-02-05T16:03:25Z")
Hi Ed If the account manager is in a connected object that is connected to the organisation then you can add a connection to the account manager in the Opportunities form and filter the connection by Organisation. This will then only show the Account Managers connected to the organisation in the opportunities. Text formulas can’t be displayed in form views. The other option is to look at coding it, but I would need a bit more context. If you’d like you can message me and we could discuss if you want. Craig ---
**Author:** ![EdCooper15510](https://avatars.discourse-cdn.com/v4/letter/e/9de053/32.png) [@EdCooper15510](https://forums.knack.com/u/EdCooper15510)\ **Post date:** [February 5, 2024, 4:57pm UTC](https://forums.knack.com/t/connection-fields-on-form/15654/5 "2024-02-05T16:57:30Z")
Hi Craig. I don’t know how add a connection to the account manager field in Opportunities form specifically. If that’s done, and the Organization is selected in Opportunities will it then display the Account Manager (read only) from the Organization table? There ideally should be a feature where once the connection is made and you select the key field (Organization) in Opportunities drop as many fields (read only) on the form. ---
**Author:** ![CSWinnall](https://sea2.discourse-cdn.com/flex020/user_avatar/forums.knack.com/cswinnall/32/3631_2.png) [@CSWinnall](https://forums.knack.com/u/CSWinnall)\ **Post date:** [February 5, 2024, 5:29pm UTC](https://forums.knack.com/t/connection-fields-on-form/15654/6 "2024-02-05T17:29:45Z")
No this is not possible in Knack. You can’t dynamically display fields from a connected object in a form. Even with the filtering option they would still have to select the manager from the list. You could get the organisation filled in then redirect to a details view (Using submit rules) once the form is submitted. Then in the details view you can display all the fields from both objects. For this to be done with code an API call would have to be made once the Organisation has been selected as there is no way to know the organisation before they fill out the form. Craig ---
**Author:** ![EdCooper15510](https://avatars.discourse-cdn.com/v4/letter/e/9de053/32.png) [@EdCooper15510](https://forums.knack.com/u/EdCooper15510)\ **Post date:** [February 5, 2024, 5:46pm UTC](https://forums.knack.com/t/connection-fields-on-form/15654/7 "2024-02-05T17:46:02Z")
Craig, I’ll have my dev dept look at an API. I understand. Don’t you think this concept should be part and parcel for Knack? If you can do this on a grid you should be able to do this in a form Display the ‘Connection’ fields to drop on the form. All other competitors that I’ve looked this comes standard. ---
**Author:** ![CSWinnall](https://sea2.discourse-cdn.com/flex020/user_avatar/forums.knack.com/cswinnall/32/3631_2.png) [@CSWinnall](https://forums.knack.com/u/CSWinnall)\ **Post date:** [February 5, 2024, 6:15pm UTC](https://forums.knack.com/t/connection-fields-on-form/15654/8 "2024-02-05T18:15:10Z")
Yes it’s something we struggled with at the start but we have found ways to work with it. You can find info about the knack API here: > **[Using the API](https://docs.knack.com/docs/using-the-api)** > > The API is used to make requests to create, retrieve, update, or delete records that are stored in your Knack apps.Requests are made for records from either a specific object in your app or a specific view on one of your pages.Object-based requests... My advice if you go down this road is to use view-based API calls. Craig ---
**Author:** ![EdCooper15510](https://avatars.discourse-cdn.com/v4/letter/e/9de053/32.png) [@EdCooper15510](https://forums.knack.com/u/EdCooper15510)\ **Post date:** [February 5, 2024, 6:37pm UTC](https://forums.knack.com/t/connection-fields-on-form/15654/9 "2024-02-05T18:37:01Z")
OK Thanks. I’ll pass on to the devs.