Forum Discussion

CameronLee's avatar
CameronLee
Qrew Member
4 years ago

Create a report that connects associated data to a specific record

Hello, I need some help trying to create the right data entry structure for the report I would like to have.  I have a specific list of names and every week each persons sales a quantity of ite...
reports and charts
CameronLee's avatar
CameronLee
Qrew Member
4 years ago
Hello,  Here's an example of what is needed.

Within this one form I would like the data to right of each person's name to be associated to that person only.   I can then pull reports for that specific persons performance.




------------------------------
Cameron Lee
------------------------------
MikeTamoush's avatar
MikeTamoush
Qrew Commander
4 years ago
Can you explain a little more about what data is currently entered into the system?

Are you saying right now you have a table where you enter the name, number of photo sessions, number of orders, and total revenue? Is this all in one table?

I don't fully understand your ask, but it sounds like what you will need is a parent table of employees, then a child table of 'Weekly data'. On the weekly data table you will have some way of determining the week (perhaps its a start and end date?), then all your data entry points. All your reports you want to look at will be made on that child table.

------------------------------
Mike Tamoush
------------------------------