Access DB routine to look up values in two table and based on the value calculate the new value.
## Deliverables
1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done. 2) The Access DB with all tables, quieries or what ever is necessary 3) Complete ownership and distribution copyrights to all work purchased. I want three tables 1st Table (Object) Field: Name(Description Field), Reusability ("N","L","M","H"), Complexity("L","M","H"), Effort (this needs to be calculated based on Reusability and Complexety) 2nd Table (Complexity) This needs to be a table with the following values Object Type Low Medium High Conversion 12 21 31 3rd Table (Reusability) Re-Use Factor H 0,25 L 0,75 M 0,50 N 1,00 Here is how it should work Step 1: Enter Describtion Step 2: Enter Reusability (N, L, M, or H) Step 3: Enter Complexity (L, M or H) Step 4: Calculate effort based on Step2 and Step 3. For example if Reusability is N and Complexity is L the effort should be 12. You get the idea. You need to take the Complexity and multipley it with the reusability.
## Platform
Access DB Version 2002