Topic: Dynamic request
I will try to explain a problem essence.
There is a general table where the data for documents is stored. Also there is a second table where what columns are specified it is necessary for for one document type (let it will be called [Doc_Colums]. More low an example from it)
The user should on the form in "a field with the list" select document type and push the button. After it should be deduced the table with strict the columns which are specified in the table [Doc_Colums]. (Also it was possible to edit fields)
How it is possible so to implement dynamic request?
It turns out if to select document should deduce 4 columns.
Example of filling of the table [Doc_Colums]:
DocName Columns ---------------------------- DocNum DocDate Account Note . Date_DTZ . DocID . DocNum . DocDate
Such document types now 18, also will grow. So a variant with creation for each document type to create the form - disappears.