One to Many -> One to One????

[potami]

I have a database of help desk call data with several tables. Each call creates a Problem_ID number in Table_A, which is used to track the issue until resolution. The Problem_ID is also in Table_B followed by a Work_Description (text) and Work_Description_ID (number, index). As subsequent work is completed, additional records are created in Table_B, each having a unique Work_Description_ID. Very often, a given Problem_ID has multiple Work_Description_ID's.

I am creating a Form that I would like to display a Problem_ID and all of its Work_Description fields on one page. It needs to be a form, because I want to input follow up info about each Problem_ID.

Is there a way to design a query that will yield one record per Problem_ID and have the associated Work_Description's combined into one field, or each appear in a separate field? I could then pull this query's results into my form.

Any thoughts are much appreciated.

Potami.

 

[THoey]

I haven't done this yet, but I think you create a subform based on the MANY side, and then add it to your main form that is based of the ONE side. Look up subforms in the help and they might have a wizard or examples to guide you... Terry M. Hoey