tbl Membershiptype
MembershipName
text
unique
Discount
number
between 0 and less than 1
tbl SafeNumber
SafeNumber
unique
number
6 digits
PinNumber
unique
number
6 digits
CreationDate
date data is created
MembershipName
linked to tblMembershiptype
MainConcierge
dropdown box to select from ConciergeName
ContentInHand (nested table?)
multiple rows - able to add/delete
for each rows
eg:
Content (text) Has Been Archived? (drop down/radio box)
2000 Y
2001 In Progress
Africa Y
2009 N
(can sort/filter by “Has Been Archived”)
LifestyleInfo (nested table?)
multiple rows - able to add/delete
for each rows
eg:
Name (text) Description (text)
Wine Likes wine
Cars Likes small cars but only photos
Family Likes family photos
In Layout “Customer Detail”, “Safe Number” tab should be a drop down box - if a value is entered instead of selecting an existing value, tbl SafeNumber will appear under “Safe Information” tab
tbl CustomerCommunication
CustomerName (linked to tbl Customers)
ConciergeName (drop down linked to tbl Concierge)
ContactMethod (drop down, can add values)
ProjectRelated (boolean, yes/no)
If yes, dropdown box appears and can select from Projects relating to Customer)
Description (text)
Date (default is current date, can be changed)
Outcome (text)
In Layout “Customer Detail”, “Client Communication” tab should have this table
tbl/layout Products
remove “reorder level”
remove anything with regards to reordering
rename “Service” to “Tech and Service”
change “price per hour” to “Price”
tbl/layout Project
If “Product”, then calculate item discount on item based on “MembershipType”, if “Service” then no discount on item
add checkbox “Is Complimentary” to each row of product
add discount to each row
If “Is Complimentary”, discount is 100%
button in Project to “Create Invoice”
translate information in Project to tbl/layout Invoice - go to invoice record
This kind of project is our forte. Our team can definitely complete this for you. This project is pretty straight forward. I just have a few questions for you for discussion
HIGHLY interested with your project. I'm ready to start right now. I'm an individual developer and my completion rate is always 100%. I STRICTLY BITE only WHICH I CAN CHEW.
Knock me please