Attempting to build a form that will be web compatible, but the table itself gives the above error when i test it - which basically says i need to add a primary key to the table the form is based on.
I have a field in one of the original ODBC tables that i use to generate the web table that i would like to use as the primary key, but how do i assign it as such? In normal access, you can just select a field as the primary key during the design.... but in the web based access db, the menus are different and i can't work out how to do it.
Any ideas? The only suggestion i've found so far would to add a new field, autonumber it, then use SQL to specify that as the primary key... but really i want to use a number that has some sort of relevance to the original data.
Any help would be greatly appreciated.... thanks in advance!