how to make this kind of tables

[engmsosman]

everyday there's 10 items and thier scores .. so it should be like this ((12 jan===> item1=50% item2=66% item3=80% .. etc)) .. i need somehow to open the days table to find that item column is already filled with the 10 items (or whatever written in the items table) and wait me to enter thier score .. it that possible???

[NTC]

if there is always 10 items (and no more) per day then keep it simple. use a single table with 21 columns; 1 for the date and then 2 for each item (i.e. Item1Name, Item1Value)

be sure to buy a textbook at Amazon or any large book store. it is difficult to work with a database without this assistance.

[engmsosman]

K.I.S.S! yes why not! .. that solve it temporarily .. thanks!