Can someone make me a simple program for a fee?

[Yuniverse]

I need to make a database program for a dry cleaner with a simple interface.
I can afford to pay only upto $100 for your effort. If that's too small... i'm sorry.

What i would need is to have these things
1. Customer # (0001) for example. (automatically assigned incrementally)
2. Name:
3. Phone #: (it would be great if it was masked like so (xxx) xxx-xxxx
4. Conveyor #: (A####) masked with an alphabet followed by 4 numbers - user would input this as well.
5. Invoice # - (#####) five digit - also input by the user
6. Date checked in with time
7. Date checked out with time
8. Status (simple "open"/"closed") when the status is selected to be closed, the conveyor # has to reset so other records can access the conveyor #(other clothes can be hung on that conveyor #)

One has to be able to look up the record by inputing any one of these four things: Phone #, Name, Invoice #, Conveyor #

This may not be so hard to make, but it is difficult for me. Can anyone do this?

thank you,

Yuniverse

 

[EagleKeeper]

You have PM

 

[Yuniverse]

thanks Eaglekeeper,

I sent you a pm

 

[minendo]

This could be done in Excel in about 5 mintues.

 

[Yuniverse]

I was thinking of something like this
Click here for a simple diagram

 

[Yuniverse]

In the diagram, I forgot about the resetting the status after the customer picks up their clothes.
However, i think it would work if you make it so that the rack would reset if they pick up the clothes and thereby entering the pickup date(the second date).

 

[vshah]

you're not paying $100 for a homework assignment are you?

-Vivan

 

[Yuniverse]

Originally posted by: vshah
you're not paying $100 for a homework assignment are you?

-Vivan

hehe...
if i was doing a homework assignment, i wouldn't be able to afford it.

I just don't have the time and knowledge to do it myself, that's all.