demicay2669
Registered User.
- Local time
- Yesterday, 23:12
- Joined
- Aug 22, 2013
- Messages
- 39
I created a web database for use on SharePoint. And I was able to publish it to SharePoint today. But to make it web compatible I had to remove my row source Data I used to make my combo boxes fill the way I needed them to. I created these on the form Property sheet, not using a lookup in the table development.
These are the fields and tables they were linked to:
cmbFailureTypeCode from tblFailureCode
cmbContainmentCode from tblInterimContainment
cmbRootCauseCode from tblRootCause
cmbCorrectiveCode from tblCorrectiveCode
The records in each of these tables make up the options I need for the combo box fields.
This code is one example of how I linked the fields to the tables:
Since its a web database is it possible for me to link these tables, so that my combo boxes pull there list info from there respected tables?
My attached database is the one published to SharePoint.
Any help would be much appreciated. Thank you
These are the fields and tables they were linked to:
cmbFailureTypeCode from tblFailureCode
cmbContainmentCode from tblInterimContainment
cmbRootCauseCode from tblRootCause
cmbCorrectiveCode from tblCorrectiveCode
The records in each of these tables make up the options I need for the combo box fields.
This code is one example of how I linked the fields to the tables:
Code:
SELECT [tblCorrectiveAction].[CorrectiveActionCode] FROM tblCorrectiveAction;
Since its a web database is it possible for me to link these tables, so that my combo boxes pull there list info from there respected tables?
My attached database is the one published to SharePoint.
Any help would be much appreciated. Thank you
Attachments
Last edited: