Can we use two source table or more in a page in AL BC365?

(0) Share

Report

Posted on by peopleeater

I've created a card page, now what I'm trying to do here is that I have a table that I created, and the "No. Series", now the main data source is my Custom Table, but I want to use the "No. Series" table too, and want to access fields of that table in my "Card Page".

Basically, the problem is that the "Card Page" already has my Custom Table as its source table, and I also want to access the "No. Series" fields in this page. Is there a way to do that?

I'm kinda new to Microsoft Business Central AL Development. So, Please help me out.

All responses (5)

Answers (2)

peopleeater 67 on at

Like (0)

Report

RE: Can we use two source table or more in a page in AL BC365?

Jaffrey Bulanadi, Thanks
Verified answer

YUN ZHU 85,845 Super User 2025 Season 1 on at

Like (0)

Report

RE: Can we use two source table or more in a page in AL BC365?

Hi, Two simple examples, hopefully give you some hints.

https://yzhums.com/24974/

https://yzhums.com/25011/

Thanks.
ZHU
Verified answer

Jeffrey Bulanadi 1,730 on at

Like (0)

Report

RE: Can we use two source table or more in a page in AL BC365?

Hi People,

What can you do is create a new page and make the PageType property as cardpart/listpart depends on your requirement and set the source table to no. series table.

Then on your Card Page, embed the new page by using part syntax. Please see the below image.

https://docs.microsoft.com/en-us/dynamics365/business-central/dev-itpro/developer/devenv-designing-parts
Suggested answer

Amit Baru 3,029 on at

Like (0)

Report

RE: Can we use two source table or more in a page in AL BC365?

Hi,

Create New subpage of No. series and add or attach into the Custom Card page.

For More Info use the below link

https://erpconsultors.com/link-main-page-and-subform-page-in-d365-bc/

Regards

Amit Sharma

www.erpconsultors.com

https://www.linkedin.com/in/amit-sharma-94542440/

Pls press Yes if info is useful.
Suggested answer

Inge M. Bruvik 1,029 Moderator on at

Like (0)

Report

RE: Can we use two source table or more in a page in AL BC365?

Create a code field in your custome table.

f.ek a code field called No.serie type code lenght 20.

Define a table relation for this field to the No. series table.

Example from one of my tables:

field(36; "No. serie "; Code[20])

{

TableRelation = "No. Series";

Caption = 'No. serie';