Calculating formulas within a form

Calculating formulas within a form

 Hi All

I am running a form where values are imported from look up fields which are then categorised into a specific group that is represented by a number. 

I am wondering if by inputting the number, and not commiting the data to the database at this stage, that I can perform a script or function that would enable me to generate a look up list (checkbox) within the form that then displays specific data relevant to the number input so that I have the ability select choices from a list.

appreciate any guidance

many thanks in advance