Something Like 3D Design Table?????

[johann201]

In this database the Tables are:
Materials (Material_ID, Material_Name, etc.)
Users (User_ID, User_Name, Date_modified, Hour, etc.)
Enviromental Values Of Materials (Ev_ID,Cretarion_01, Cretarion_02, etc.)

So i want to build a relation like a 3d axis system like that:

X: Materials
Y: Envirometals Values Of Materials
Z: Users​

So for each user may correspond with 1 or all of the materials and for each material many enviromental values(cretarion_01,cretarion_02, etc.)

Namely i want to do a database where a person saves a number of material (1 or all) and for each material a number of Enviromental Values(1 or more).

I make a relation (see attach file)

What is your opinion about that?
It would be a broblem if the PK's type is text?

Thanx in advance....

Happy new year​

 

[johann201]

Sorry i forget it...

there is a way, when i add persons (materials and e-vslues for them),
to be automatic a number in connection ID field??

Johann