Multiple Values for a field from a related table

  • Thread starter Thread starter e krok
  • Start date Start date
E

e krok

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

TIA Ed Krok
 
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.
 
Back
Top