MS Access: Many to Many Question

[TiziteLayinLow]

I have designed a database and using access as a simple front end for it.

I have a complete ER diagram that was graded by my instructor and works great.

I got tables/relationships and everything entered into the access database.

Im tryin to create a form, I created a query using the wizard, and then a form with the wizard pointing back to the query.

The data shows up great, but I cant edit it??? any ideas?

thanks - matt

 

[BFG10K]

You can't edit data that comes from multiple tables in a single form. You can display the data but the portion you are editing needs to come from one central table. If you want to edit the other tables you'll need to use subforms which are linked from the main (central table) form.

 

[HardcoreRobot]

yes, you can use subforms (i like putting tabs on the page and putting each subform on a tab)

then in properites you specifiy how each subform relates to the main form

its not pretty but it works