From customer wish to test automation
Our customer wishes to extend standard Dynamics 365 Business Central with an elementary feature: the addition to the Customer table of a lookup field to be populated by the user. This field has to be carried over to the whole bunch of sales documents and also needs to be included in the warehouse shipping.
Data model
Even though the purpose of such a field will be very specific, we will generically name it Lookup Value Code. As with any other lookup field in Business Central, this Lookup Value Code field will have a table relation (foreign key) with another table, in our case, a new table called Lookup Value.
Figure 6.1 schematically describes the data model of this new feature, with the new table in the middle and the extended standard tables on the left and right sides:
Figure 6.1 – Lookup Value data model relational diagram
The Lookup Value Code field has to be editable on all tables except for the posted...
