Want a brainteaser? Here's one...

[durexlw]

Imagine functions (as in coding): there is a function call, to each function there are parameters and whereas the names and the amount of parameters is specific to a function, the value of that parameters is specific to each individual function call.



For example:
Add (Number1,Number2)
ADD = function
Number1 & Number2 = parameters specific to the function

Add (5,3) = function call
where the numbers 5 and 3 are parameters specific to the function call

-

What I would like is a datamodel that can do this: if I add a new function, it should present me with the parameters specific for that function, but the values for those parameters should be different for each 'function call'. I'm really struggeling with this one and I'm in need of some help.

... is this even possible?

[jzwp11]

Welcome to the forum!

I'm not sure what you are really asking, but a datamodel implies a table structure. Since a function can have many parameters, that describes a one to many relationship, so a table structure might look like this

tblFunctions
-pkFunctionID primary key, autonumber
-txtFunctionName
-txtDataTypeReturned

tblFunctionParameters
-pkFunctionParametersID primary key, autonumber
-fkFunctionID foreign key to tblFunctions
-orderNo (order of the parameter is important to the function)
-txtDataType (the data type of the parameter)
-txtOtherRestrictions (such as allowable numbers etc.)