• We’re currently investigating an issue related to the forum theme and styling that is impacting page layout and visual formatting. The problem has been identified, and we are actively working on a resolution. There is no impact to user data or functionality, this is strictly a front-end display issue. We’ll post an update once the fix has been deployed. Thanks for your patience while we get this sorted.

MS Access: Many to Many Question

T

TiziteLayinLow

Senior member
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
 
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.
 
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
 
You must log in or register to reply here.

TRENDING THREADS

Back
Top