Urgent Help Needed for new system

[AK67]

Hello all being my first post i will try and make this as clear as possible...

its a new system my company.

my manager would like if possible the system to work in this way..

firstly a form whcih will book rides so when opened will ask current members to etner their card no which is a 16 digit number always beggining with 5555 1946 and the customer no. added on which is 0000 0001.

If a customer has not registered another link so they can register and enter details and once done this press enter and message generating a new 16 digit card number 1 mroe than the highest number in the system. new members are allocated 2000 points on their card and points are taken off when booking new rides plus a 10 point booking fee.

then a button will be clicked to take back to reserve rides which allows the customer to book a ride using the ride id and ride number on a specific Session of which there are 3 times in the day 11:00, 14:00 and 17:00 and with a maximum of 5 places on each ride during each session being able to book.

once session ID and time,date selected the next box should show the available rides

if member does not have enough points to book an error message is displayed.

I know this all sounds confusing and ive attached my progress so far its very basic being a basic user i hope users out there can help as this has to be done before friday

the attachment is below thankyou for all the help

 

[chris davies]

you are looking for a multiple tabled, relational database. You need a customer table with customerID, name etc all the usual customer information, 16 digit card number? set the id (primary key)
to a 16 digit number (5555194600000001) and then set it to autonumber.

alloting values and deducting them is a simple matter of mathematics, for example customercredit.value = customecredit.value - 100, not rocket science really.

you will also need a rides table with you specific times set as field names , again, set the command button to add one to the value of the field until it reaches 5 then stop the user from clicking the button.
an onclick event with a simple if statement should suffice:
if fieldname.value <5
fieldname.value = fieldname.vlaue + 1
end if

I would have thought that the rideID and Ride number were one and the same?

By Friday, well that's not going to happen is it? I have only touched on the basics here, you need to plan your application properly or it will not work as you would like it to.

 

[KeithG]

Its Friday