Kindly help me design a database for the solution below:
I am looking for a simple solution - please help and oblige
I need a small day to day application which
1. has a vendor master with vendor name and phone no. - people who supply us material
2. has a item master with list of items we deal in
1st thing we need is we have two list boxes, where the user selects (also can search) items he/she need to order ,
the items get saved to items to order.
2nd the admin user - sees what is to be ordered and then - in a datagrid view enters quantity which has to be ordered.
3rd the admin user - assigns items to vendors by selecting vendors from a drop down and again this screen has two list views
the items which are assigned to the selected vendor is saved.
4th a report is generated
with Vendor name and phone number on top and the item list along with quantity below it.
also if sms feature can be added so that a usb modem / data card - having a com port can send sms to the vendors to who
order has to be placed with item name and quantity.