I'm not terribly great with access, so I don't know if I'm even starting this off correctly. Here is the relationship of the tables:
What I'm wanting to to is create a form that will update the "PropertyPieces" table with the id from Property and id from Pieces.
The pieces table contains a small list of about 20 or items. A single "property" could have many "pieces" it's related to. I really don't know if I set the joins properly to achieve this either.
Anyway, the next thing I'd like to do is create a form that will show a single property, the list of all possible pieces, have the user select which pieces the property is related to and then have it update the "PropertyPieces" table with the appropriate ids.
Let me know if I'm totally off my rocker on my approach here, and if there are any resources you can point me to if it's just too complex.
Thanks!
What I'm wanting to to is create a form that will update the "PropertyPieces" table with the id from Property and id from Pieces.
The pieces table contains a small list of about 20 or items. A single "property" could have many "pieces" it's related to. I really don't know if I set the joins properly to achieve this either.
Anyway, the next thing I'd like to do is create a form that will show a single property, the list of all possible pieces, have the user select which pieces the property is related to and then have it update the "PropertyPieces" table with the appropriate ids.
Let me know if I'm totally off my rocker on my approach here, and if there are any resources you can point me to if it's just too complex.
Thanks!