Establishing relationship automatically

Question

Hello,I am working on survey report. Depending on survey outcome, I'd like to request additional notes. Structure is as follows: Require Notes (yes/no) -<Survey Q&As -< NotesI am trying to create a conditional dropdown in Notes, so it shows a list of Survey Q&As that are related to "yes" record of Require Notes only.Before doing this, I need to create relationship between "yes" record of Require Notes and Survey Q&As; but I would like relationship to happen automatically (when "add notes" check box is ticked in Survey Q&As) . I would also like to have every record of Notes table to be automatically related to "yes" record of Require Notes. Is this possible? Is there another way of doing this?Thank you for your help.------------------------------Arkady------------------------------

BrianCafferelli · Answer

Hi Arkady, to relate all the Q&A records automatically to the "yes" record, you can set the reference field with a default value. For example, let's say you're using Record ID# as the key field on the table where the "yes". Let's also assume for a minute that the Record ID# for the "yes" record is 1. Then, you can edit the field properties for the reference field and set it to 1.

------------------------------
Brian Cafferelli
------------------------------

Sign up

Login to the community