Many to One Relational List Field

[lsmall]

I am a bit stumped.

In table A, each record represents one medication for one patient. Within the table, a patient can have many records (1 for each medication that the patient is on). There are also many patients in Table A.

Table B is related to Table A by a patient identifier. I have a checkbox field in Table B populated by a value list of all the medications of interest. For a given patient in table B, I want every matched medication for that patient in Table A to autopopulate the checkbox field in Table B. So multiple medications in Table A can show up in one checkbox field in a record in Table B, even though in Table A these would represent individual records.

It seems to me I should use a list function of some sort, but I haven't been able to get it to work.

Any help would be appreciated.

Thanks.

[Fitch]

Have you defined the value list for your checkbox field to show only related values from Table A?

[lsmall]

Have you defined the value list for your checkbox field to show only related values from Table A?

Thanks

As best as I can figure, that shouldn't be an issue. I want all of the items in the value list to APPEAR in the checkbox field and those that are matched in Table A to be checked, while all the others remain unchecked. For simplicity, I think you can forget about the checkbox field entirely and just think of it as a text field, but I want a list of all matched medications to populate the single text field. If you then change the text field to a checkbox field showing all of the medications in the value list, then they should all appear as unchecked except those that are related to the specified patient, which will be checked.

[Fitch]

I think I understand now. In that case, your initial idea should work: using List(Table A::items) would produce a return-separated list of the items, which would then appear as selected checkboxes.

[lsmall]

I think I understand now. In that case, your initial idea should work: using List(Table A::items) would produce a return-separated list of the items, which would then appear as selected checkboxes.

Ok I got it. I was just doing the list syntax wrong. I didn't realize I could just have one list expression to list the same field across multiple records. Looks good now.

Thanks