M
mbaycura
I have a table of contacts, in that table I have fields including first name,
last name, initials, and department (such as R&D, marketing, operations,
etc.). I have another table of ideas that includes a resources multi-valued
field. the ideas table is where a user would select one or more contacts
that are resources for a particular idea.
I have yet another table & form that is a project update cover page. There
is a one-to-one relationship between any given idea record from the idea
table and a project update cover page record. On the idea form all resources
are selected in the same multi-valued field, however on the project update
form, I am trying to display the resources from the idea related to the
project update, but want to split them into different fields/display boxes
based on their department.
So in other words I'm trying to take the resources mulit-valued field from
the idea table and display them by department on the project update form. I
have created a query that properly creates a table putting each resource on
it's own line and sorts for a specific department, but I can't figure out how
to get a display field on project update form to display the results.
Ideally there is only one line for each department with the names seperated
by a comma or other seperator. right now, the best I've managed is to get a
sorted pull down list to show up, but since nothing is automatically checked
nothing displays.
I'm thinking one way might be to create an appended string of some kind
based on my department query results column and just display the single
string on the project update form, but I don't know how to do this.
Anyone have any suggestions?
Thanks.
last name, initials, and department (such as R&D, marketing, operations,
etc.). I have another table of ideas that includes a resources multi-valued
field. the ideas table is where a user would select one or more contacts
that are resources for a particular idea.
I have yet another table & form that is a project update cover page. There
is a one-to-one relationship between any given idea record from the idea
table and a project update cover page record. On the idea form all resources
are selected in the same multi-valued field, however on the project update
form, I am trying to display the resources from the idea related to the
project update, but want to split them into different fields/display boxes
based on their department.
So in other words I'm trying to take the resources mulit-valued field from
the idea table and display them by department on the project update form. I
have created a query that properly creates a table putting each resource on
it's own line and sorts for a specific department, but I can't figure out how
to get a display field on project update form to display the results.
Ideally there is only one line for each department with the names seperated
by a comma or other seperator. right now, the best I've managed is to get a
sorted pull down list to show up, but since nothing is automatically checked
nothing displays.
I'm thinking one way might be to create an appended string of some kind
based on my department query results column and just display the single
string on the project update form, but I don't know how to do this.
Anyone have any suggestions?
Thanks.