Multiple Values for a field from a related table

[e krok]

Question?
How can I enter multiple values for a field by obtaining
them from a related table

TIA Ed Krok

 

[John Nurick]

Hi Ed,

Usually it's not a good idea to do this: better to leave them in the
related table and use a query or report to collect them when needed,
using a custom VBA function to concatenate the field values from the
related table.

There's a suitable function at www.mvps.org/access. I think it's called
fConcatChild() but if you search for "concatenate" you'll find it.