Enter a field based on number input.

I have 2 tables. One is called intake and the other is called household. Currently the way things work are simple. First data entry person inputs data in to the intake table screen .Then saves the record. Afterwards he or she would have to hit back to list to go back to the list view of the table then also hit back to master table to view the record and make a selection of going to add the info for houshold. I would like to be able to eliminate the extra foot work in navigation. I have a filed called family size. Is it possible that when the data entery person inputs the number of people in family example 3 then he or she can have some kind of an auto popup or way that would allow them to input data in to houshold with out having to navigate to that area of master and list and master. Hopefully I am clear. Thanks . <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=question&id=7352&image=1&table=forumtopics' class='bbc_emoticon' alt=':rolleyes:' />