I'm not sure if this thread should be in table or if I need a query for this.
Currently I have to tables: table 1 with material and material dimensions( Width, Length, Height and weight). In Table 2 to I have Material, Weight ,Substance and substance weight.
Material In table 2 is linked with Table 1 but I want if you select a material in table to the corresponding weight if also copied from table 1 to table 2.
Can this be done automatically in a table or do I need a query for this?
Thnx in advance
Currently I have to tables: table 1 with material and material dimensions( Width, Length, Height and weight). In Table 2 to I have Material, Weight ,Substance and substance weight.
Material In table 2 is linked with Table 1 but I want if you select a material in table to the corresponding weight if also copied from table 1 to table 2.
Can this be done automatically in a table or do I need a query for this?
Thnx in advance
