Requests.PR_NO is the key
USERS.USER_NO is the key
Prayed table has both PR_NO and USER_NO referencing their parent table
When I go to add a new child from the Requests form, it brings in the values for PI_NO which is another referenced field in the Requests table. I cannot figure out why.
If I manually add the correct PR_NO in the data source, then the child correctly appears.
Any tips on where to look for my error?