I want to make calculated fields, but it seems that this is only possible for fields in the main table. Is this correct, or are there a way to make calculated fields for flat table or hieararchy table
Just out of curiosity, can you tell me your requirement about the calculated fields in the look up tables.
If you look at the concept these tables are supposed to give us a list form which we pick up some values. If these themselves are calculated then why can't have the field as a part of the main table?
There are two reason I want to use calculated fields in lookups:
I am working with a book database,the main table i will use for books, in the look up tables i wil have for example authors. The author ID i would like to calculated base on an autoid and som calculations.
The other reason is for search, using a calculated field to able to do an search on the content of several fields. This field will contain all values from relecvant fields.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.