I have a db that has a main table with a PK of STRNumber. This main
table has other tables that contain software, models and documentation
information based on the STRNumber. All have a PK of STRNumber.
The main table link to the software and models are one-to-one and to
the documentation table it is one-to-many. So each STRNumber will have
only 1 Software record, 1 Models record but can have many
Documentation impacts.
The software, models and documentation table each have a field called
PREPNumber (prefaced by SW, Models and Doc). Ex: SWPREPNumber,
DocPREPNumber. Each PREPNumber field is a text field and can contain
many PREPNumbers, ex: PREP-123, PREP-124, PREP-125, etc.

I have a form for the main table that I want to add a field to, that
would contain all the PREPNumbers for that particular STRNumber and
combine them into one field on the main STR form. I need that field
to go out an look for any SWPREPNumbers from the SWPREPNumbers field,
any ModelPREPNumbers, and all Documentation PREPNumbers. Since the PK
for all the tables is the STRNumber field, it would only combine all
the PREPNumbers for that particular STRNumber.
I'd appreciate any help. I'm kind of new to MS Access.