Solved: Adding a Many to Many not referencing correct pare... - Page 2

Lucinda_Mason · 04-23-2020 07:41 AM

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?

Thanks.

Lucinda_Mason

View_All_Requests is a Slice based on the Requests table.

OH MY!!! I had PI_NO as the lable for the Requests table, NOT PR_NO. That fixed it.

I wonder if that messed anything else up? When is a label used? This is the first time I’ve done many to many in this App.

Thank you so very much? You are a great detective!

View solution in original post

Adding a Many to Many not referencing correct parent