G
Guest
Paying $100 to the first person who builds it and it works. This is a very
simple DB, but need it quickly. Don't even begin before contacting me.
Email me at (e-mail address removed) if interested. It must be done by Dec.
31 to even be considered. You can also call me at 469-371-7989.
---------------------------------------------------------------
The following are the requirements:
Table: Customers // populated by Form: Customers
Field: Customer Name
Field: Customer Account (Yes/No)
Field: Customer Phone Number
Table: Refrigerants // populated by Form: Refrigerants
Field: Refrigerant Type
Field: Refrigerant Notes
Table: Orders // populated by Form: Order Form
Field: Date of Order
Field: Order Number (Month + 001(sequential counting up)) // This number
starts over every month. This is the primary key.
Field: Customer Name
Field: Customer Account (Yes/No)
Field: Customer Phone Number
Field: Refrigerant Type
Field: Refrigerant Weight
Form: Customers // Both adds and modifies
Customer Name
Customer Account (Yes/No)
Customer Phone Number
Form: Refrigerants // Both adds and modifies
Refrigerant Type
Refrigerant Notes
Form: Order Form
Date of Order
Order Number (Month + 001(sequential counting up)) // This number starts
over every month.
Customer Name // drop down selection
Customer Account (Yes/No) // autopopulated by selecting customer name
Customer Phone Number // autopopulated by selecting customer name
Refrigerant Type // drop down selection
Refrigerant Weight
Report: Date specified to Date specified, number of total orders.
Report: Date specified to Date specified, weight sold of each refrigerant
type.
Report: Date specified to Date specified, Orders by specific customer
simple DB, but need it quickly. Don't even begin before contacting me.
Email me at (e-mail address removed) if interested. It must be done by Dec.
31 to even be considered. You can also call me at 469-371-7989.
---------------------------------------------------------------
The following are the requirements:
Table: Customers // populated by Form: Customers
Field: Customer Name
Field: Customer Account (Yes/No)
Field: Customer Phone Number
Table: Refrigerants // populated by Form: Refrigerants
Field: Refrigerant Type
Field: Refrigerant Notes
Table: Orders // populated by Form: Order Form
Field: Date of Order
Field: Order Number (Month + 001(sequential counting up)) // This number
starts over every month. This is the primary key.
Field: Customer Name
Field: Customer Account (Yes/No)
Field: Customer Phone Number
Field: Refrigerant Type
Field: Refrigerant Weight
Form: Customers // Both adds and modifies
Customer Name
Customer Account (Yes/No)
Customer Phone Number
Form: Refrigerants // Both adds and modifies
Refrigerant Type
Refrigerant Notes
Form: Order Form
Date of Order
Order Number (Month + 001(sequential counting up)) // This number starts
over every month.
Customer Name // drop down selection
Customer Account (Yes/No) // autopopulated by selecting customer name
Customer Phone Number // autopopulated by selecting customer name
Refrigerant Type // drop down selection
Refrigerant Weight
Report: Date specified to Date specified, number of total orders.
Report: Date specified to Date specified, weight sold of each refrigerant
type.
Report: Date specified to Date specified, Orders by specific customer