Customer account EDT without referential integrity

Question

I maintain a table of some specific configuration informations for customers.

The identifier of this table is the customer account, the CustAccount EDT.

Now I face a problem : this configuration information must sometimes be defined before the customer is created.

Is there a way to create a non-restrictive EDT, which will be related to CustAccount (we can select the value among existing accounts), but which allows other values than existing accounts ?

Answer 1

Yes. You want to look at examples in the AOT that use the base enum TableGroupAll. For your case, you'd probably create a new EDT called TableAll (Which exists in AX2012).

Look at how \Data Dictionary\Tables\AssetDisposalParameters works or anything that uses \Data Dictionary\Base Enums\TableGroupAll.

Essentially it's like a 2-field key, where you'd have Table+CustAccount connect to the CustTable, but All would just be a blank CustAccount.

EDIT: Here is an AX 2009 XPO example that you can quickly see working well.

Also, don't do what the other poster suggested. Even in AX 2012 you'd want to do something similar to what I suggested unless you have some very special requirements.