Two References into new table

[hthransprangers]

I have a Parent/Child table relationship in my app and now I want to introduce a "grandchild" table.

In my Parent table I have the field: ID

In my child table I have the fields: ID and Detail ID

In my new grandchild table, I have the fields: ID, Detail ID and InvLineID.

I have references set up for ID and DetailID, but ONLY Detail ID is populating automatically when the user drills down into the app to get to the form that populates the grandchild table. What is the trick to get my ID field to also populate?

I'm happy to share my app with anyone that would be willing to try to help me.

Thank you in advance to anyone that can help!

[OptimiX_XcrY]

[id]=[detailid].[id] ?

[hthransprangers · Accepted solution]

I was able to figure out my issue by setting this as the "Initial Value"

LOOKUP([_THISROW].[DetailID], "AppTimeSheetDetail", "DetailID", "ID")