News and Announcements icon

Dynamics 365 CommunityForums Business Central forum Table creation with PK

Business Central forum

Suggested answer

Table creation with PK

(0) Share

Report

Report

Posted on by Community member

2

Hi everyone,

I'm new in Business central development. Need ur help regarding table creation in business central.

I'd created master / child tables for GL entry with defining VoucherNo as PK and foreign key in Master / Child tables and designed the pages accordingly.

When entering the data in /ListPart/, i get error /Text type of key field cannot be automatically split/.

Can anybody help in this regard.

Thanks

GUlbaz

////

Data Type of Voucher No is

field(1; VoucherNo; Text[15])

{

DataClassification = ToBeClassified;

TableRelation = /GB Voucher Master/.VoucherNo;

}

Categories:

All responses Img

All responses (2)

Answers Img

Answers (0)

YUN ZHU 68,395 Super User 2024 Season 2 on at

Like (1)

Report

Table creation with PK

Hi, it looks like you are using the AutoSplitKey property? You can refer to page 46 "Sales Order Subform" and pay attention to setting the AutoSplitKey property and DelayedInsert property.

https://learn.microsoft.com/en-us/dynamics365/business-central/dev-itpro/developer/properties/devenv-autosplitkey-property?wt.mc_id=DX-MVP-5004336

https://learn.microsoft.com/en-us/dynamics365/business-central/dev-itpro/developer/properties/devenv-delayedinsert-property?wt.mc_id=DX-MVP-5004336

Hope this can give you some hints.

Thanks.

ZHU
Suggested answer

tanya07 1,535 on at

Like (1)

Report

Table creation with PK

Hello,

Can you please show the error here ?

Also what is the data type used for VoucherNo ?

Helpful resources

Quick Links

Leaderboard

#1

André Arnaud de Cal... 290,252 Super User 2024 Season 2

#2

Martin Dráb 228,089 Most Valuable Professional

#3

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans