I needs the following Databases created:
- Database for external / internal Partners (Database would contain contact details, working hours and location,ticket prices and stock volume (min / max) of each ticket sales office
- Finance Database for all transaction / should be able to be used to run different reports
- Database with active clients / customers - this database will include - internal badge number and fist and last name and email address. This database data will be uploaded from a excel sheet
- Database for all loggins actions
- Master database for events
I need the following Data entry screens / access points:
For ticket Sales Office
when logged in they should be able to enter the Badge ID and then see the name of the member and email addy
they should be able to see if the entered badge ID is a valid member
they also should be able to see a purchase history for the last 2 weeks for all ticket offices
they also should be able to see a stock value for the their ticket office / cash value
Data Admin entry screen
should be able to add ticket purchases for the different ticket offices
should be able to add external / internal partners
should be able to add event ticket sale infos
Treasurer access
this access should have a overview of all sales and financial records
Committee member account access
this should have access to the current finance situation of the club (read only)
This should be special reports that the treasurer can define
Trustees member account access
this should have access to all finance records (read only)
Ticket Sales accounts for events
This account should be able to sell tickets for special events
Events Host account
this account should have access to all data entries and should be able to correct them if needed
This is just a quick overview of the needed filemaker database
I can provide more infos and detailed pictures of how the different screens layout should look like and how each database should be interacting with the other databases
I currently work as a database manager for a small company in London. The database that you are looking for has a lot the same features i already developed for them.
It should be easily finished within a week however i would suggest showing a first draft after a few days for initial feedback.
Let me know if you would to view previous databases I have developed!
Kind regards,
Duncan
$400 USD în 14 zile
5,0 (4 recenzii)
4,2
4,2
4 freelanceri plasează o ofertă medie de $854 USD pentru proiect
Hello. To host a file on a server and the file isn't done on FM 15, there are services that start at $15/month. what you want can't be done for the budget you posted, it is too extensive.