Hello mod_harbour Team,
Hello Otto,
For my soccer club I made a member program a while ago with a online SQL database. Works great and is for only a few people. Installed the exe on there pc and of we go ....
Now I need to make 'something' for all the members (220 person) add then the exe on every pc is off cource a problem. From what I've been reading last year from post of Otto, Mod can give a sollution.
Concept : (How would you proceed and is there a sample that have some of this ideas allready build in ?)
The kids should be able to select there soccer cloches from the site : (Shirt, Soks, Short, Sweater, Cap,.... Max 30 items), but each person belong to a team and eacht team has its own selection of gear
We need a admin login where we can fill a simple 3 xbrowse with
Data Browse 1. Persons : (ID, Person Name, Team, last order date)
Data Browse 2. Teams: (U6,U7,U8,U9...)
Data Browse 3; Material (eacht team can have a different selection of material)
u6 (shirt1 - Size , short1 - Size, soks - size, caps1,...) all with a picture to see what it is
u7 ( short1, caps1, fleece)
every piece can have a size (lets start with only 2 settings (36 - 62 ) and (S,M,L,XL,2X,3X,4X,5X) So they can select a piece and also select the size for it
I don't think for the admin it is nessesary to have any dialog to fill data in. Direct into browse is ok.
Second login for the person self to place a order
So when person 1 log's in with his name, the program can get the name from file and sees what they can select, getting the options from the team file, suppose 5 items to select
Marc Venken : U6
Shirt red : quantity : .... pleace select size (36-62) .....
Soks : ..... (38-46) ......
Place the order button.
This order data should be saved somewhere that I can get to it by a desktop program that read the file for processing offline.
A notice of any kind to the desk would be helpfull
Can you assist on this ?
Thanks for ideas...
Marc