Need Help With Access 2010

[Trishnalynn]

I have created two tables: ‘Business Role Test’, ‘DC Roles to Course’.
I have attached the zip db for review - its only 512k.


I need to search the Business Role Test table for values from the DC Roles Course table (Business Role - SAP ECC) column and find a match in the Business Role Test table.
When a match is found, I need the second column that contains the values of the classes from the DC Roles to Course table, to be added to the field called ‘Training Courses’ in the Business Role Test table.

I started a macro but wasn’t sure enough to complete the commands.

I’d appreciate help.

Thank you!

[June7]

Why are TrainingCourses, Business Role - Other, Business Role - SAP ECC, Applications fields set as multi-value?

[Trishnalynn]

Why are TrainingCourses, Business Role - Other, Business Role - SAP ECC, Applications fields set as multi-value?

Hi June 7,
They are check boxes from sharePoint in those fields. Many rolls to many courses is what I'm hoping to accomplish.

[June7]

Fields set up as multi-value can't be interacted with same as other fields. In other words, can't do a simple expression to populate the field, such as:

Me.TrainingCourses = "xyz"

And using SQL to edit multi-value fields requires special syntax.

Use of multi-value field complicates what you want to do.

Review:
http://office.microsoft.com/en-us/ac...001233722.aspx
http://stackoverflow.com/questions/6...ield-in-access
https://www.accessforums.net/program...vba-21259.html

[Trishnalynn]

Fields set up as multi-value can't be interacted with same as other fields. In other words, can't do a simple expression to populate the field, such as:

Me.TrainingCourses = "xyz"

And using SQL to edit multi-value fields requires special syntax.

Use of multi-value field complicates what you want to do.

Review:
http://office.microsoft.com/en-us/ac...001233722.aspx
http://stackoverflow.com/questions/6...ield-in-access
https://www.accessforums.net/program...vba-21259.html

Thank you for the links June 7! I'm going to look those over and in the mean time, I'm going to export to Excel and try to run a macro on it after parsing out the coma delimited fields into individual cells.

[June7]

I don't know that export to Excel will be a simple task either because multi-value fields are not comma separated values. In spite of the data appearance, that is NOT a single string of characters. Hopefully the links will clarify.