• Sign in to Neowin Faster!

    Create an account on Neowin to contribute and support the site.

  • 0
Sign in to follow this  

Dreamweaver Help!

Question

thankins    0

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

Share this post


Link to post
Share on other sites

0 answers to this question

Recommended Posts

There have been no answers to this question yet

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

  • Recently Browsing   0 members

    No registered users viewing this page.