Database help please

[knuckles]

help with database i made a table with the attributes pts1 pts2 pts3 and then enterd the record and i need a form so when you enter something in attribute pts 1 it shows pts1 pts2 and pts3 like auto fills the others in

the dater base is for Avce ict results i want to enter ums scores and have it change to the grades automaticly
can somone please help some one must have dont this

[vgbreazu]

Hi,

you can't solve this problem within the usual database software alone, you would have to use some kind of development environment like Delphi or Visual Basic. Both of them have wizards wich will allow you build a form with the functionality required (access a database table, show the rows in a tabular form, and so on). Or you may also use Microsoft Access or Visual FoxPro which include not only the database but also the ability to create the user interface (your form).

Hope this helps.
Georg

[lonelybug]

yon can try to implement these constraints with some development tools that can build this type codes conveniently.