How to establish the relationship between these tables in Access?

痛苦学习

Table 1 Table 2 Parameter 1 Table 3 Parameter 2 Table 4 Parameter 3 ...
Alloy Name Name Temperature Parameter 1 Value Name Temperature Parameter 2 Value
Name 1 Name 1 Temperature 1 Value 1 Name 1 Temperature 1 Value 1
Name 2 Name 1 Temperature 2 Value 2 Name 2 Temperature 2 Value 2
Name 3 Name 1 Temperature 3 Value 3 Name 2 Temperature 3 Value 3
Name 4 Name 2 Temperature 4 Value 4 etc. etc. etc.
            Name 2 Temperature Value 5
             Wait wait


The above table is a name of a parameter that changes with temperature, a table of parameter values ​​at different temperatures

I want to ask whether the primary key of these tables can be defined like this: The primary key of table 1 is the name of the alloy, and the second table ... The primary key of the table is temperature and time as the primary key.

What's more important is how to establish the relationship between these tables? When querying, you can query all the parameters of the alloy by querying the alloy name.

Troublesome XDJM can tell me, wait for it, I thanked him first

小老鹰

If there is no duplicate alloy name, you can use the alloy name as a keyword.

痛苦学习

Thank you brothers upstairs for your reply, and please trouble guide me, how to establish the relationship between these watches?

ilgold

What the younger brother wants to ask is whether the primary keys of these tables can be defined like this: The primary key of Table 1 is the name of the alloy, —————————————— Yes, no problem

Table two: The primary key of the table is temperature and time as the primary key. I do n’t know if this is possible or not? No, if the temperature may be repeated, you ca n’t define it like this, and create an automatic number field as the primary key.

痛苦学习

Experts help

痛苦学习

thank you very much

hanyuliao2

Didn't read too well

Give each alloy a unique number

Alloy Name Name Temperature Parameter 1 Value Name Temperature Parameter 2 Value
Name 1 Name 1 Temperature 1 Value 1 Name 1 Temperature 1 Value 1

Are two different measurement plants of the same alloy at the same temperature? In this case, you can add time