T
TAWise
My database lists the 700 employees in a particular division. There are 48
organizations within that division and an employee could support one, two,
three, or four organizations. I have set up an org table for the 48 orgs and
created a roster table and form using the orgs table as four separate
dropdown boxes to be able to choose choose the one, two, three, or four orgs
supported for each employee. All of this works fine. Problem: I would like
to add a field on the roster form or roster report that captures the one,
two, three, or four selections made for the orgs. However, all I get is the
ID numbers and not the actual orgs that were selected. I am using control
=[Org1]&[Org2]...etc. I have tried changing column counts, bound column, and
even tried changing fields from numbers to text and text to numbers. Any
help would be appreciated.
organizations within that division and an employee could support one, two,
three, or four organizations. I have set up an org table for the 48 orgs and
created a roster table and form using the orgs table as four separate
dropdown boxes to be able to choose choose the one, two, three, or four orgs
supported for each employee. All of this works fine. Problem: I would like
to add a field on the roster form or roster report that captures the one,
two, three, or four selections made for the orgs. However, all I get is the
ID numbers and not the actual orgs that were selected. I am using control
=[Org1]&[Org2]...etc. I have tried changing column counts, bound column, and
even tried changing fields from numbers to text and text to numbers. Any
help would be appreciated.