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