I need a database built.
More specifically:
1) I need be able to enter in (Field #1) Name, (Field #2, 3, 4, 5) to be discussed later (ie charges or categorized exp).
2) To be able to generate report based on date and email list to client.
3) All items need to be stored in data base and at anytime able to pull up report based on any field.
4) All active clients should be viewable to easily enter new date and new charges for that date. Clients should be able to be hidden from active screen if needed.
5) Each client can have multiple charges or expense on one date
Example:
Input Screen
Last Name (Text Input)
First Name (Text Input)
Room #: (Text Input)
Account #: (Text Input)
Date of Service: (Calendar)
Type of Service: (Drop Down with programmable choices that will be added onto at a later time) I must be able to manipulate <add or delete> on this list. ***If D is selected, then hide from active screen****
Code 1: Drop Down with programmable choices that will be added. This is different then type of service) I must be able to manipulate <add or delete> on this list.
Code 2: Same as Code 1 <Same list can be used as code 1>
Code 3: Same as Code 1 <Same list can be used as code 1>
Report:
In excel format
Date of Service Last Name First Name Room# Account # Code 1 Code 2 Code 3