Film Transfer

Hello I need a program that control the transfer of film copys from a warehouse to cinemas. I have the program, but some routines must be fixed and a new part, with advertising material must be done. I am sending a file with some forms, After I can send the databank model You need to make some routines and make the program works 100% properly. In the end I need 4 Reports. The program is nothing more than a product traker. If a copy came from a lab you must know where it is. The program will be used for a warehouse, that centers and distributes copies of films, the objective of the program is to manage all the copies and its respective movements, since its production in the laboratory, passing for all the movements, until arriving its destruction. Existing movements: Entrances- All the copies are registered in cadastre in the system, . When the copy enters in the warehouse for the first time, exists an event (table event; codigo_evento=1, entered descricao_evento=primeira), this entrance will have to appear in the report of entrances, as well as all the other entrances (table event; codigo_evento = 6, descrição_evento=retorno of the cinema). All the movements of the copies are recorded in the copia_historico table, and its current localization is recorded in the table copia_localização. Programming and exit of the warehouse-The warehouse receives the programming from the deliverer, contends the following information: nº of the programming, has filmed, copy, version, date of exit of the warehouse, date of entrance in poster, date of return, numbers of days, exibidor, cinema and room. After I register in cadastre it of these information, is made an order expedition to separate the copy to to forward it. Programming and exit of other places Fold(renew) of the Same programming - All copy, must be one week in the cinema, however, the cinemas can renew per some weeks, and pra each week must be made a fold. The fold is the extension of some programming, and serves not to generate delays, being modified the date of return and the number of days. Transferences between cinemas - Transference of copies, is when some copy is in some cinema and goes directly to another one, without passing for the warehouse. Almost the same thing is dome with material, but material has no copy number, you need to control the inventory, if the material is in or out ## Deliverables 1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done. 2) Installation package that will install the software (in ready-to-run condition) on the platform(s) specified in this bid request. 3) Complete ownership and distribution copyrights to all work purchased. ## Platform VB, SQL and Crystal Report