Hi everyone,
Got a problem with a many to many relationship. So much so I've started a new DB to test out whats wrong.
got a table called property
Got a table called owners
Got a junction table
Related them together using LandID and OwnerID via a many to many relationship using the junction table. The junction table contains PropertyID & OwnerID as numbers and primary key references.
Now when I create a form it gives me an error telling me that the field cannot be updated and the junction table has no data inside it and I loose the data.
Banging my head up against a brickwall!!!
Hi Reema,
What you have described regarding the table structure and relationships, seems fine. But you have not described the form, or it's row source so it is difficult to suggest any help.
- What do you expect the form to do?
- How have you structured the form's row source? Is it a query or a table?
- Which field cannot be updated?
Cheers,
Docendo discimus.
Please consider:
- Thanking those who helped you. Click the reputation icon
in the contributor's post and add Reputation.
- Cleaning up when you're done. Mark your thread [SOLVED] if you received your answer.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks