I'm a Dynamics NAV/Navision developer and helps partners and end-users with their NAV implementations. I do everything from third-party management advisory, training to new NAV teams, project management, training, setup and development.
Do you want to hire me to help getting your project a success? Then contact me via dropping one email from linkedin
Expertise in end-to-end development of software products from requirement analysis to System Study, Documentation and Testing. Demonstrated abilities in analyzing information system needs, evaluating end-user requirements, custom designing solutions, troubleshooting for complex information systems management. Deft at carrying out risk analysis, impact analysis, project reviews and documentation. Strong Problem solving & Technical skills coupled with confident decision making for enabling effective solutions leading to high customer satisfaction as well as low operational costs.
Certifications:-
Microsoft Certified Technology Specialist -Dynamics
Microsoft Sure Step Certified Professional
Moderator at DUG Forum
Specialties: • ERP Implementation
• Client/Server Programming
• Coding, Testing, troubleshooting and documentation.
• Database Tuning and SQL
• Database Performance
• Debugging large programs
• Project Management and Resource Management.
View all posts by Ammolh Saallvi
17 thoughts on “How to extend TableRelation Property-Business Central”
Thanks for your answer, Ammolh.
Yes, but I think you must extend “No.” field Tablerelation, not “Type” Tablerelation property. Type don´t have any Tablerelation:
modify(“No.”)
{
TableRelation = if (type = const(Retail)) Retail;
}
}
Hi,
Thanks a lot.
However, if i want modify a standard table relation, can i do it ?
For exemple if i want to change the standard table relation of field [No.] Table sales line.
Add condition of item relation like this :
TableRelation = if (type = const(Item)) Item where (“MyField” = Const(true);
Ammolh, Did you really try this? In above can we do, simply table relation to one particular table irrespective of type or what I am trying to ask is changing the earlier behaviors? You have added one more type and for that you are changing tableRelation, what if for example I want to open item table for type is resource and resource table for type item. Can that be done?
This is a great post, thank you. I tried to modify Location on Purchase Lines table, and change the tablerelation to filter warehouses. But it does not take. no errors.. just doesn’t do anything.. any advise:
modify(“Location Code”)
{
TableRelation = Location where(Code = Const(‘WEST’), “Use As In-Transit” = CONST(false));
}
Same with me. I tried to modify “Sell-to Customer No.” table relation on Sales Header but there was no effect
When I select customers, all customers appear unfiltered
I modified the table relation like this :
modify(“Sell-to Customer No.”)
{
TableRelation = Customer where(“Global Dimension 1 Code” = field(“Shortcut Dimension 1 Code”));
}
Good morning, I have a question: Could be ” modify(“No.”)” instead “modify(Type)”?
LikeLike
We should take field which we are modifying using extension .If No field need to modify then we can use that field.
LikeLike
Thanks for your answer, Ammolh.
Yes, but I think you must extend “No.” field Tablerelation, not “Type” Tablerelation property. Type don´t have any Tablerelation:
modify(“No.”)
{
TableRelation = if (type = const(Retail)) Retail;
}
}
LikeLike
Yes .I will update that .Thank you
LikeLike
Thank to you, great post, I didn´t know we can do that in BC.
LikeLike
Thanks for identifying that mistake. There are lot of things we can do n BC and as I finding that posting it on my blogs so it will help others.
LikeLike
Hi,
Thanks a lot.
However, if i want modify a standard table relation, can i do it ?
For exemple if i want to change the standard table relation of field [No.] Table sales line.
Add condition of item relation like this :
TableRelation = if (type = const(Item)) Item where (“MyField” = Const(true);
LikeLiked by 1 person
This is what I write
LikeLike
Ammolh, Did you really try this? In above can we do, simply table relation to one particular table irrespective of type or what I am trying to ask is changing the earlier behaviors? You have added one more type and for that you are changing tableRelation, what if for example I want to open item table for type is resource and resource table for type item. Can that be done?
LikeLike
Yes I already tried this and using in one of the app
LikeLike
This is a great post, thank you. I tried to modify Location on Purchase Lines table, and change the tablerelation to filter warehouses. But it does not take. no errors.. just doesn’t do anything.. any advise:
modify(“Location Code”)
{
TableRelation = Location where(Code = Const(‘WEST’), “Use As In-Transit” = CONST(false));
}
LikeLiked by 1 person
Same with me. I tried to modify “Sell-to Customer No.” table relation on Sales Header but there was no effect
When I select customers, all customers appear unfiltered
I modified the table relation like this :
modify(“Sell-to Customer No.”)
{
TableRelation = Customer where(“Global Dimension 1 Code” = field(“Shortcut Dimension 1 Code”));
}
LikeLike
Thanks, Amol, it really helps.
LikeLike
I am sorry but it’s not filtering in the table reationship.
LikeLike
Since we cannot change the flow field, we can add a field in the Group field it will help us to add more field detail.
The only solution, I got.
LikeLike
Let me check
LikeLike