Data from Multiple Table on page

Business Central/NAV Developers Forum
1

Hello All,

I am working on NAV 2009. It has employee table. My requirement is to add additional field in employee table.

Because of licensing, I am not able to add extra field in table, so I have created another table to store required details.

Can anybody please guide me how to join these two table to show details on one page (Employee Card).

When I check SourceExpr, only fields from Employee table is listing there.

Regards.

2

any help?

Regards.

3

?
If you are allowed to create a new table, you should be allowed to create a new field in table 5200 as well. Usually a new field in a standard table has to be in ID-range 50000…99999. Have you tried that?

But to have data from two tables in one window you have to
-create a new form containing new field(s).
-the on Employee Card insert a control for subform; set subformId for this control to the id of the new form + relevant filters.

4

Hi Anfinnur,

Thanks for your reply. I have tried using ID-range 50000-99999. It solved my problem. Thanks again.

Second option you suggested is for Form whereas I am using NAV 2009 - Page. Can u please suggest me the same solution for page and not a form.

Regards.