I need form to be filled out asking 4 questions then depending on 1 of the questions (revenue) go to a table?
... that has revenue and produce calculations and reports from that column in the table. for instance if revenue is $70.00, the table has revenue ranges column 1 $10-$19.99, Column 2 $20-%58.99, column 3 $60-$79.99, column 4 $80-%100 . The system needs to select Column 3, because revenue is $70 and it falls between $60 and $79.99. then produce reports with data in Column 3 and some calculations. Can your system do that?
Answer:
Yes FormNX can do it with slight modifications.
You can create 3 tables each having data for each of the revenue range. And use conditional fields to show the relevant table based on the range of input.
Regarding generating of the report please explain more on what exactly you need here.