web

You’re offline. This is a read only version of the page.

Dynamics 365 CommunityForums Finance | Project Operations, Human Resources, ... Entity key for a table...

Finance | Project Operations, Human Resources, ...

Unanswered

Entity key for a table with RecId

(0) Share

Report

Report

Posted on by ..

1,847

Hi,

I have two tables:

Header table, with an index of allow duplicate No (AccountNum, Id, Date, RecId)

Lines table, with an index of allow duplicate No (RefRecId, LineNum)
It's relation with HeaderTable is:
Line.RefRecId = Header.RecId

Now, i was asked to create a new table that has a relation with the LinesTable (each Line can have more than one record in this new table that is related to it)
I made the relation as this:
NewTable.RefRecId = Line.RecId

And I made index as (RefRecId, LineNum)

Now i need to create an entity for this new table, in order to import records to it via DMF for an existing Line
How to design the entity? and what will the entity key be?

Categories:

Dynamics 365 Finance

I have the same question (0)

All responses Img

All responses (0)

Answers Img

Answers (0)

Helpful resources

News and Announcements

Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft

Our Community Code of Conduct has been updated!

Quick Links

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1

Sohaib Cheema 841 User Group Leader

#2

André Arnaud de Cal... 753 Super User 2025 Season 2

#3

CA Neeraj Kumar 566

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans