Forms / Subforms

[dummy1]

Hello All,

I have made a database Erp . In this database i Have a form Machineparameter. Where i update the machineparameter values, etc.
Parameterrange 1 = (with multuply values) for different Parts of the machinery.
This goes up to 30 Parameterranges

Now i have a form Artikels, where i want to show the machine parameter values. Now every standard artikel can be made with multyply Parameterranges up to 3. I want to show this in every artikel standard
witch Parameterranges are possible.

Anyone an idea if i have to do this over subforms , or maybe something else?

By subforms (3 for 3 Paramettanges) i get problems with the links because i only have one table Machineparameter and 1 Query.

Attached the Mainform Artikels where i Input 2 subforms Machine Parameter 1 and Machine Parameter 2 but this does not work.... can link by Artikel ID ... but this is giving an error

Regards

dummy

 

[dummy1]

Think its hard to understand without an example included

Included a scratch from my database. frmArtikelTuft is Mainform.

2 subforms frmTufmachineParameter that i would link at frmArtikeltuft for each artikel.

I have a black out, can t find why this not working.

Or maybe there is an easier way to link more standard Machineparameters for each artikel, Each artikel can be made on more than one machine. but is limited by 2 or max tree. thats why i want to fix the machines setup for each new Artikel in advance as guidline in produktion

Regards Dummy

 

[dummy1]

Oops forgot Database