|First of all: "Sorry for my english!" I recently have created a calibration database via Ms Access DBMS. Here is the model:
Each tool has "name abzarLa" field that is actually "Tool's English Name" that comes from ToolList Table. Here is sample values of "ToolList" Table.
now it's time to explain my problem: each Tool based on its "name abzarLa" relates to its specific "Data Table" which contains Calibration data results with specific fields. (One To Many relationship => each tools has multiple row in "Data Table") Here is data table that uses for insert "Pressure gauge" results:
And here is data table that uses for insert "Oven", "incubaor", "cold Incubator" results:
Ok, So we have a Tools table and multiple "Data Tables". How can I design "Data Tables" and create relationship between "Tools" table and "Data Tables" base on "name abzarLa" field?
One Design is:
but I want each tool only relates with its specific [Data Table]