OK, i have a small problem which i realy need some help. any help appreciated.
I have 3 tables, one table has only list of names wich is linked to a main table that contains names,date,list of items a person holds and so on.
In the name table when there are data(list of names available) you can click the left corner of each name and u come up with that main table(the information belonging to that particular person(name). e.g
main table
AutonumberID Name Item Date
2 lee coke 2/2/3
3 lee cake 4/5/3
name table
Name TotalItem
lee
jack
sue
so when lee click yo can see 2 raws of data with information for lee..what i want to do is to creat anothr column for name table call it totalItem. so when there is 2 x lee name in main table the name table colum total item is entered " 2 " next to lee...i think it has something to do with Count but not sure how to do it..by the way i might need to set the result to be multiplayed by 10 later..so we get 20 insted of 2 in total item....anyone can tell me how please reply me ASAP,,thank you...need ur help
I have 3 tables, one table has only list of names wich is linked to a main table that contains names,date,list of items a person holds and so on.
In the name table when there are data(list of names available) you can click the left corner of each name and u come up with that main table(the information belonging to that particular person(name). e.g
main table
AutonumberID Name Item Date
2 lee coke 2/2/3
3 lee cake 4/5/3
name table
Name TotalItem
lee
jack
sue
so when lee click yo can see 2 raws of data with information for lee..what i want to do is to creat anothr column for name table call it totalItem. so when there is 2 x lee name in main table the name table colum total item is entered " 2 " next to lee...i think it has something to do with Count but not sure how to do it..by the way i might need to set the result to be multiplayed by 10 later..so we get 20 insted of 2 in total item....anyone can tell me how please reply me ASAP,,thank you...need ur help
