Access 2007 and SharePoint 2007 linking issues

[codeWarrior007]

Hi, I created an access database with cascading combo boxes with the information for each combo box stored in separate tables. I wanted to put the database on SharePoint 2007 but when I put it up there, it made me get rid of my primary key and it inserted it's on "ID" primary key. Now instead of getting the text from the tables to populate the combo boxes, it get's the ID number. I have tried several things to get around this such as accessing the specific column (tbl1.Columns!N ame) that i needed from the table. There seems to be no way to change the primary key or delete the "ID" field. I even tried using SQL statments to get the particular column from the list. However i have had no luck. Is there anyone who may be able to help me with this?

[NeoPa]

I can't help off the top of my head.
Perhaps you could provide an example of what the old version does and what the new version does. The SQL of the ComboBox would be required and an explanation of exactly why the new results you get are not right.

[MMcCarthy]

Hi, I created an access database with cascading combo boxes with the information for each combo box stored in separate tables. I wanted to put the database on SharePoint 2007 but when I put it up there, it made me get rid of my primary key and it inserted it's on "ID" primary key. Now instead of getting the text from the tables to populate the combo boxes, it get's the ID number. I have tried several things to get around this such as accessing the specific column (tbl1.Columns!N ame) that i needed from the table. There seems to be no way to change the primary key or delete the "ID" field. I even tried using SQL statments to get the particular column from the list. However i have had no luck. Is there anyone who may be able to help me with this?

The only thing I can think of is to remove the primary key designation from the primary key and let it get imported as a normal field. Then set the combo box bound column to this key instead of the new primary key.

Mary