How can I look up the previous days data & show it on the same form as what the user will enter (current day)? I have test cases that teams provide daily via a form. The Parent table is Planned Test Cases and the Child Table is Daily Test Cases. Here is my end goal: on the child form, i'd like to show the "previous days test results" next to current day (which will be blank until the user enters the info). The previous days test information is to remind them of what happened the day before.
Now, how best to do that? Do i do a reverse look up to the parent based on date (MAX[Today]) to pull the fields like Passed, Failed, Blocked, etc to the parent? Then do i map them back to the child??? if so, how do i do that? I tried to set up a reverse look up but did something terribly wrong i suppose.
I've heard of "snapshotting" but i cant get that to work either. HELP...this part is due Wednesday!!! :-( I'd attach a pic but it doesnt appear that i can.