Hi all, sorry I didn't know which forum this fitted into so hope this is ok?
Could you please help me to work out whats going on here? I have had a database in use for about 7 years and the table relationships have always been fine.
I am trying to move the database to sharepoint. To that end I have been importing everything into a blank 'web database' in Access 2010 and setting up Lookups and relationships between the tables.
I believe I have done everything right, but after the conversion to a web database my queries are no longer updatable. I believe I have worked this out as being down to the relationships.
Pre converting to a web database many relationships were (rightly) detected as one-to-one, but post converting to web database the same relationships are being detected as one-to-many... which I think is the cause of the queries not being updatable.
Can anyone give me a hand? Many thanks in advance!
Relationships table pre move to web database:-
Query Pre Web with One-To-One Relationships
Query Post Web with One-To-Many Relationships (Not Updatable)
p.s. I have had people ask before about why tel numbers etc aren't included in the CustomerDetails table... when I learnt Access I was told that blank fields were erroneous data and should be put into separate tables. All those tables do not necessarily have entries which is why they are separate.
Many thanks again for any help!!
Could you please help me to work out whats going on here? I have had a database in use for about 7 years and the table relationships have always been fine.
I am trying to move the database to sharepoint. To that end I have been importing everything into a blank 'web database' in Access 2010 and setting up Lookups and relationships between the tables.
I believe I have done everything right, but after the conversion to a web database my queries are no longer updatable. I believe I have worked this out as being down to the relationships.
Pre converting to a web database many relationships were (rightly) detected as one-to-one, but post converting to web database the same relationships are being detected as one-to-many... which I think is the cause of the queries not being updatable.
Can anyone give me a hand? Many thanks in advance!
Relationships table pre move to web database:-
Query Pre Web with One-To-One Relationships
Query Post Web with One-To-Many Relationships (Not Updatable)
p.s. I have had people ask before about why tel numbers etc aren't included in the CustomerDetails table... when I learnt Access I was told that blank fields were erroneous data and should be put into separate tables. All those tables do not necessarily have entries which is why they are separate.
Many thanks again for any help!!
