hi, i've been experiencing an issue with submitting when the backend is SQL.
I have 2 tables CUSTOMER and REQUESTS table. Both tables has "ID" as a primary/unique key. And i have joined both these tables by "customerid". When i use access as a back end DB, i have no problem submitting with the same primary key and relationship. However, I now require to change the DB to SQL and it does not allow me to submit anymore. I checked the Data connection wizard and right at the end, it says "Submit option: Disabled. A many to one relationship might exist in the data source."
What am i missing??? please help!!!