• 0

Dreamweaver Help!


Question

thankins

Hello.

I am working on a project and have ran into a little snag, and was curious if it is possilbe to do what I want to do.

I have three tables with these feilds

tblApplicant - StudenID, Name, MajorCode, Gender, Race

tblAllocation - StudentID, AwardNo, AwardAmount(amount given to student)

tblAward - AwardNo, AwardName, MinAmount, MaxAmount, TotalAvailable

I would like to have a form with the students name, ID, and Award Number (NOT EDITABLE BY USER, auto updates when award name is selected.) Award Name will be selected from drop down menu (AwardNo is based on Award Name), as well the amount the student will recieve which would be entered via textbox. Both of those being pulled from the tblAllocation, and tblAward.

I would also like to validate the amount the user enters to make sure it is less than the MaxAmount, and more then the MinAmount for that award, as well make sure that the amount is what is avaliable in the totalAvailabe field

Does anyone have any ideas how to do this, mainly the Award Number auto updating when the user chooses a Award Name via the dynamic menu

Link to post
Share on other sites

0 answers to this question

Recommended Posts

There have been no answers to this question yet

This topic is now closed to further replies.
  • Recently Browsing   0 members

    No registered users viewing this page.