I want to know the use of the properties "FormRef" and "CacheLookup" and "CreateRecIdIndex" Table properties.
These are properties u ll c whenever u right-clicked on any Table in Ax.
thx
Hi
- FormRef: this is the look up form for a field. Take a look at the field / extended data type of field ItemId of InventTable table.
- CacheLookup: data is cached for look up event.
- CreateRecIdIndex: AX will create an index for the field RecId. This field is created automatically for all tables in database. You can let AX to create index for this field if you are going to select data by this field.
Hope this help
Hi,
FormRef is the form that will be displayed when one right clicks and selects 'Go to Main Table' on a field having an EDT whose relation points to that table ... therefore you can say it is the default go to main table form
CachleLookUp is when Ax allowed to use cached data (might be outdated data) rather then going to look for data in the database. For more information about each option available please read this article: http://msdn.microsoft.com/en-us/library/bb314693(AX.10).aspx
CreateRecIdIndex is used when your table design does not allow for a unique key index i.e. there is no primary key or primary key set therefore you can create set this property to true so that the RecId unique becomes active and used. Only set it to true if you actually need it or else you might have a performance hit.
Hope this helps