Visual Basic portfolio fill program 2

Portfolio program. See the two tables attached to this bid invitation. This program must find coins that are listed in the coinactualhouseinv Access Table that are not already a part of their selection that is recorded in the orderdetails table. So you have one table with all available coins = coinactualhouseinv You have a second table that records coins that have been already bought by an individual. The object of the program is to find coins that will equal a set amount of money that the client does not already own. (remember the coins he owns are already recorded in the orderDetail table. There will be a set of parameters that should be available for the person running this program. They are as follows: Customer number: ___________ a long displayed in combo box Amount of the portfolio being bought: _______________ currency No single coin over: _______ Currency Need at least ______ coins for this portfolio integer No grade less than ____ string No grade greater than _______ string Can include more than one of the same coin after all others coins have been exhausted: Yes/No What services are acceptable : PCGS , NGC, or any (Combo box) In the details table you will see that I have provided you with about 12 or so clients (check for unique customer_no) Your program should consist of a nice interface that the user can select the client ID from a combo box and then they would fill in the answers to the criteria. In reality this information will be brought in from a database but that we will do later. The coins the program selects, to meet the criteria should then (see below) ## Deliverables 1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done. 2) Deliverables must be in ready-to-run condition, as follows (depending on the nature of the deliverables): a) For web sites or other server-side deliverables intended to only ever exist in one place in the Buyer's environment--Deliverables must be installed by the Seller in ready-to-run condition in the Buyer's environment. b) For all others including desktop software or software the buyer intends to distribute: A software installation package that will install the software in ready-to-run condition on the platform(s) specified in this bid request. 3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement). *********************************************** be displayed in another form or embedded table that allows the user to say yes or no to the coins you display. The following info must be displayed: Coin_id Grade Cost Service Qty avail Ownership Qty accepted this qty the users puts in which would mean to the system that he wants to reserve these coins for that client / portfolio. Your program would then save that quantity for the user in a new table of your design and reduce the quantity in the coinactualhouseinv table by the amount you are going to add to their portfolio. ## Platform The amount you select should subtract from the total amount that you started off with and keep reducing the portfolio amount. At the end the program tries to find a coin for the remaining left over amount of money. Actually as the coins are selected only coins that would still fit the altered portfolio should be displayed on the screen showing the selected coins. The programming should be done in ADO with unbound objects. Any references to paths should be taken from an Ini file that contains where the MDB with the data resides.