Form for calculation

[CJ_London]

good luck...

[kiranair]

Is it a good idea to keep all the Genproc, ProcessStep, Parameter_Value, Parameter_Quotient in a single table and link it to tblTechno (compromising redundancy)??
Bcz all 4 are dependent on each other as shown below (In Figure ID is a primary key)
as i have already have it as Dependent combo boxes .

If yes, how should I link it to tblTechno

[kiranair]

Can I expect some solution?

[CJ_London]

sorry, did not receive a notification.

Looks like that is a good idea, but no need to compromise redundancy

In the techno table, remove the same fields, and replace with a single FK field back to this table

tblTechno
TechnoPK autonumber
newtableFK long
AssumptionFK - long link back to tblAssumptions and bound to
AdjustmentValue - double - this is the number from your 'has to be multiplied or divided with some number'
ParameterLegend - text - don't know where this fits in
sure there is more

[kiranair]

ok i ll try