| |

VerySource

 Forgot password?
 Register
Search
View: 10|Reply: 3

How to establish the relationship between these tables in Access?

[Copy link]

1

Threads

2

Posts

3

Credits

Newbie

Rank: 1

Credits
3

 China

Post time: 2020-1-6 20:10:02
| Show all posts |Read mode
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
Reply

Use magic Report

0

Threads

20

Posts

12

Credits

Newbie

Rank: 1

Credits
12

 China

Post time: 2020-1-18 01:54:01
| Show all posts
If there is no duplicate alloy name, you can use the alloy name as a keyword.
Reply

Use magic Report

1

Threads

2

Posts

3

Credits

Newbie

Rank: 1

Credits
3

 China

 Author| Post time: 2020-1-25 20:45:01
| Show all posts
Thank you brothers upstairs for your reply, and please trouble guide me, how to establish the relationship between these watches?
Reply

Use magic Report

0

Threads

5

Posts

3

Credits

Newbie

Rank: 1

Credits
3

 China

Post time: 2020-5-31 11:45:01
| Show all posts
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.
Reply

Use magic Report

You have to log in before you can reply Login | Register

Points Rules

Contact us|Archive|Mobile|CopyRight © 2008-2020|verysource.com ( 京ICP备17048824号-1 )

Quick Reply To Top Return to the list