Small and medium business | Business Central, N...

Linking two tables in Business Central using AL Language

(0) Share

Report

Posted on by M Saravanan

168

Hi Members,

I would like to know a way to link two tables (any two) and display it in a single page. Please do provide me a solution to this, with the help of AL Language in Business Central.

Thanks and Regards,

Saravanan M

All responses (2)

Answers (0)

Suggested answer

YUN ZHU 78,669 Super User 2025 Season 1 on at

Like (0)

Report

RE: Linking two tables in Business Central using AL Language

Hi, you can also use FlowField - Lookup, Query object and so on,

https://docs.microsoft.com/en-us/dynamics365/business-central/dev-itpro/developer/devenv-flowfields

https://docs.microsoft.com/en-us/dynamics365/business-central/dev-itpro/developer/devenv-query-object

Hope this helps as well.

Thanks.

ZHU
Suggested answer

Inge M. Bruvik 999 Moderator on at

Like (1)

Report

RE: Linking two tables in Business Central using AL Language

There are many ways to do that. Depending on exactly what you want to achieve.

Using list parts and card parts is one option.

You can read more about the pages types here:

docs.microsoft.com/.../devenv-page-types-and-layouts

If you only want to display data and not have them editable you can use the integer table as you datasource and simply use AL code to pick and data you want to display on the page.

But ListPart or CardPart should normally be your 1st choice.

And just for the record. You can not link any two tables together. They need to have some kind of relation between them unless you just want to display data from a table with a single record.