Skip to main content
Question

I have multiple activities and multiple categories, i need a form that allows entry of this data

  • January 16, 2018
  • 0 replies
  • 67 views
I have 10 activities and 10 categories on a crosstab form. At the cross section of each activity and each category a numerical value is entered. (See picture below).  I've been scratching my head as to the most efficient way to do this in QB but cannot come up with a solution. 
    This topic has been closed for replies.

    @Niraj - Are you just trying to enter that information in a single record in a table ? 

    You can either use a grid edit table or a many to many relationship using an intermediate table. So, what exactly are you trying to accomplish ?

    if your set of questions/ crosstab is not going to change or expand over time you can bite the bullet and create 100 fields (10x10) and capture the values in a single form using alternate field labels. This method is not sustainable when the parameters of the cross-tab change.
    Have you tried creating a Summary report? This works if you have one field (e.g., "Activity Name) for the rows of the crosstab and another field in the same table for the columns (e.g., "Activity Category").
    I think that the OP wants a data entry form.
    • NirajShah1
    • Author
    • Registered
    • January 16, 2018
    @Alex. Thanks! I thought about it but I need something where users can enter data for the middle cells. The summary report would be the end deliverable once data is entered.
    The only native way I can see would be to have a button to create the 100 blanks records and then use Grid edit to do he data entry.  But the data entry would be "vertical", not in a square format like that. 
    Yes, this does sound like it needs a Many to Many relationship.  If you make that relationship, and can make a button to create those 100 records, then it will work.

    Of course, that will lead to the question of the most painless way to make those 100 records.

    One way would be to make a parent record called like Survey Cycle or whatever, inherently a data gathering effort is called.  Perhaps they are Semesters.  

    You could make the Parent as a template record by using excel to load up those 100 blank records, buy connecting them to the proper Record ID# Parents in the two parent tables.

    Then use the wizard in the Application management to make a button to import those 100 blank records into any new "Semester".
    Terms & ConditionsAccessibility statement