Solved: Linking a child table with another child table - Page 2

Rafael_ANEIC-PY · 11-28-2020 06:02 AM

Hello friends, i’m making my first app using the relational database schema and i have a question, im making a sales app with this structure:

I want to know if i can reference the Sites child table from the Transactions child table in order to pick or add a site in the same way i could add a site from the client table using references, im aware that i could use the select() function so the user can pick a site based on the client, but then he wouldn’t be able to add a new site on the spot

LeventK

Yes it’s possible @Rafael_ANEIC-PY
You need to use a Valid_if expression for the [ClientSite] column in Transactions table.

SELECT(
    Sites[Site_ID],
    [Client_ID] = [_THISROW].[Client_ID]
)

View solution in original post