Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / how to use a extended ...
Finance | Project Operations, Human Resources, ...
Suggested answer

how to use a extended table in a form datasource

(0) ShareShare
ReportReport
Posted on by AS-30042044-0 60
i extended a table and now i want to use this table in my new form but the extended table is not set as form DataSource?
your answers will be appreciated.
  • Suggested answer
    Waed Ayyad Profile Picture
    Waed Ayyad 6,556 Super User 2024 Season 2 on at
    how to use a extended table in a form datasource
    Hi Dinesh,
     
    From the images that you sent; you mean you make extension of Sales Table and added new fields. If you see now your Datasource has the new fields? so what is your problem?
    If you are talking about, make your new custom table extends Sales Table, then you  should create new table add the new fields (Company and Mobile number) and set the property Extends in your new table to SalesTable.
     
     
    Thanks,
    Waed Ayyad

    If this helped, please mark it as "Verified" for others facing the same issue
     
  • Suggested answer
    Dineshram R Profile Picture
    Dineshram R 4 on at
    how to use a extended table in a form datasource
    Hi,
     
    I have replicated the same scenario with adding two fields in the existing table and added the table in custom form it was working fine. don't try to drag and drop your table in the form DataSource instead create a new data source and add the existing table in the property level for your reference I'm attaching the images below. If you face any issue, try to put full synchronization. 
     
     
     
    Regards,
    Dinesh
  • Layan Jwei Profile Picture
    Layan Jwei 7,266 Super User 2024 Season 2 on at
    how to use a extended table in a form datasource
    Hi Community member,

    I think it should work. For example try and drag and drop DirPerson, does it work?  (DirPerson extends DirPartyTable)
  • AS-30042044-0 Profile Picture
    AS-30042044-0 60 on at
    how to use a extended table in a form datasource
    i created a relation in table and i am using it to new form and than when i drag and drop the extended table it is not set as data source
     
  • Suggested answer
    Anthony Blake Profile Picture
    Anthony Blake 2,201 Super User 2024 Season 2 on at
    how to use a extended table in a form datasource
    Set the original table (the table you extended) as your datasource. You will be able to see the new fields that are in your extension. 
  • Layan Jwei Profile Picture
    Layan Jwei 7,266 Super User 2024 Season 2 on at
    how to use a extended table in a form datasource
    Hi Community member,
     
    What do you mean is not set as form datasource, what error are u getting if you type the tableName in the properties and save?
  • AS-30042044-0 Profile Picture
    AS-30042044-0 60 on at
    how to use a extended table in a form datasource
    yes it is of f&o
     
  • Martin Dráb Profile Picture
    Martin Dráb 230,466 Most Valuable Professional on at
    how to use a extended table in a form datasource
    You're asking in D365 general forum, but your question clearly is about a particular product and not about D365 in general (regardless of the product). Isn't it F&O?

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Congratulations 2024 Spotlight Honorees

Kudos to all of our 2024 community stars! 🎉

Meet the Top 10 leaders for December

Congratulations to our December super stars! 🥳

Start Your Super User Journey

Join the ranks of our community heros! 🦹

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,735 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,466 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans