One to Many
I have a 'Contacts' table and need to create relationships for each contact in that table. For example, Mary (primary contact) has a father (Fred), mother (Betty) and sister (Sue). I need to, while v...
Forum Discussion
Again, many thanks. I've got this concept but still not getting what I'm looking for.
I want to add a connection to Don Sloane based on a relationship between Contact table and Connections table.
Connected To is a text-multi choice field which is fine.
Then once saved I want the user to be able to go to directly to Josephine's record in the Contacts Main Form. The formula for the button (see below) is "URLRoot() & "db/" & [_DBID_CONTACTS] & "?a=er&dfid=3&rid=" & ?? which works. My challenge is that I can not figure out how to capture the record ID for Josephine as I only have the Name established in the relationship. When the user selects a Name in the Connected To field (above) how can I get the Record ID# associated with that record, Josephine in this example. I don't want to have the drop down display Josephine - 30 for example by including the Record ID# as part of the Default Record Picker.
Again, many thanks in advance!!
I want to add a connection to Don Sloane based on a relationship between Contact table and Connections table.
Connected To is a text-multi choice field which is fine.
Then once saved I want the user to be able to go to directly to Josephine's record in the Contacts Main Form. The formula for the button (see below) is "URLRoot() & "db/" & [_DBID_CONTACTS] & "?a=er&dfid=3&rid=" & ?? which works. My challenge is that I can not figure out how to capture the record ID for Josephine as I only have the Name established in the relationship. When the user selects a Name in the Connected To field (above) how can I get the Record ID# associated with that record, Josephine in this example. I don't want to have the drop down display Josephine - 30 for example by including the Record ID# as part of the Default Record Picker.
Again, many thanks in advance!!