C
Chip
Hey everyone,
I have a problem that seems like it should be easy to fix. I have a
combo box call cboTrainingSites. This cbo is filtered by
TrainingInstitutes. For example: Training Institut Joe Blow
Community College has several Training Sites, so the user picks the
Training Institute and only those Site that are affiliated with that
Training Institute are shown in the cboTrainingSites.
Each Training Site als has affiliated with it, a County and a Facility
Type. County is the name of the county and facility type are things
such as Hospital, Fire Department, etc.
So the user selects the TrainingSite, and there are two unbound
textboxes below. The first, the County one, displays the correct
county name (not the ID). However, for Facility Type, the only thing
that shows up is the ID field.
Note, all my tables are located on SharePoint. When I go to
SharePoint to view the tables, the Data Type is number, no LookUp as I
had made it. Any ideas what I'm doing wrong? I've tried all manner
of field settings, but since I cant edit Tables in SharePoint from
Access, I'm not able to change the data type to lookup. The only
thing I can do is delete the table in question, and re-establish its
presence. Then again,it comes back and gives me the number data type
again.
chip
I have a problem that seems like it should be easy to fix. I have a
combo box call cboTrainingSites. This cbo is filtered by
TrainingInstitutes. For example: Training Institut Joe Blow
Community College has several Training Sites, so the user picks the
Training Institute and only those Site that are affiliated with that
Training Institute are shown in the cboTrainingSites.
Each Training Site als has affiliated with it, a County and a Facility
Type. County is the name of the county and facility type are things
such as Hospital, Fire Department, etc.
So the user selects the TrainingSite, and there are two unbound
textboxes below. The first, the County one, displays the correct
county name (not the ID). However, for Facility Type, the only thing
that shows up is the ID field.
Note, all my tables are located on SharePoint. When I go to
SharePoint to view the tables, the Data Type is number, no LookUp as I
had made it. Any ideas what I'm doing wrong? I've tried all manner
of field settings, but since I cant edit Tables in SharePoint from
Access, I'm not able to change the data type to lookup. The only
thing I can do is delete the table in question, and re-establish its
presence. Then again,it comes back and gives me the number data type
again.
chip