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.

I have the same question (0)

All responses (5)

Answers (2)

Suggested answer

Inge M. Bruvik 1,111 Moderator on at

Like (0)

Report

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';

Was this reply helpful? Yes No
Suggested answer

Amit Baru 3,037 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Verified answer

Jeffrey Bulanadi 8,760 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Verified answer

YUN ZHU 95,574 Super User 2025 Season 2 on at

Like (0)

Report

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

https://yzhums.com/24974/

https://yzhums.com/25011/

Thanks.
ZHU

Was this reply helpful? Yes No
peopleeater 67 on at

Like (0)

Report

Jaffrey Bulanadi, Thanks

Was this reply helpful? Yes No