ClaraBarton
Registered User.
- Local time
- Today, 12:55
- Joined
- Oct 14, 2019
- Messages
- 451
I know how to concatenate fields and I know how to UNION fields but I'm stumped on a problem here that sounds so simple:
I would like to combine one field with multiple foreign keys. For instance a child has two parents with the same child ID. How do I get these two parents together into one record for a report? I use a subform to get them both together on the child form but I'd like to not use a sub report because I want it all on one line.
I would like to combine one field with multiple foreign keys. For instance a child has two parents with the same child ID. How do I get these two parents together into one record for a report? I use a subform to get them both together on the child form but I'd like to not use a sub report because I want it all on one line.