AnsweredAssumed Answered

Help with Lookup & Calculation involving 2 Related Tables

Question asked by binu.alexander on Mar 10, 2015
Latest reply on Mar 11, 2015 by bigtom

I am working on a  solution for a  Book Translation Firm .   The Translators Have to Give Weekly Reports on their work.

 

I have 2 Source Tables 

A : List of Books , Total Chapters and Verses

B : List of Books with Individual Chapters and Verses

 

Screen Shot 2015-03-10 at 12.16.48 PM.png

 

This the the Report  Format  C

Screen Shot 2015-03-10 at 12.25.58 PM.png

What I managed to create so far is  

1)  Drop down menu to select a book (math , science ,etc)

 

2) Display Total Chapters and Total Verses ( green  : are Looked up from TABLE A Automatically)

 

What I also want to do

 

1)Have the user enter chapters done (number)

 

2)Calculate Number of Verses Done (blue ) based on Chapters Done ( By Referring to Table B)

 



Any Ideas on how to go about it ? I got stuck at this point


 

Outcomes