One Form to Update 2 Related Tables?

[zannix]

Hi guys,

I'm sort of new to MS Access, but as a student I have a project that I'm due to complete to Monday. So I would need your help!

My theme is "CD shop" and there are 2 tables that I'm trying to make a form out of. They are related many-to-many and therefore have a 3rd, relational table.

1st table is: Artists
2nd table is: Albums



Since one artist can have multiple albums and vice versa, I've created a 3rd table: Artists_Albums with the IDs of both tables, and made both those IDs a primary key in the table.

Now... I want to create a form which will be called "Enter new Album", and it should allow the user to enter a new album into the database, without first entering the artist info, then the album info, and then connect those two through the relational table...

I want to make a form that allows to do all that in one step. A user should enter the name of the album and the artist for that album, and those 2 should then be connected in a database.

Please help me solve this problem!

Kind Regards,
Zannix

[June7]

Sounds unusual but maybe this is what you want:

A form bound to the Artists_Albums table with two combo boxes, one for each ID fields. Have on this form two subforms, don't link to the main form. Bind one form to the Albums table and one to the Artists tables. You can set these two forms to only allow new records, not display existing. Might need code to requery the two comboboxes after artist or album is added.

[cap.zadi]

Hey,

I think it would be best for you to watch all the tutorials from Mr. Firchild and its all about the "CD Shop" as well.

http://www.youtube.com/watch?v=_7ZtN...ure=plpp_video


Regards


Zee

[alive]

First try to make relationship between the two tables with the ID as unique field and then while creating form choose fields of both the tables.


A detailed tutorial will be posted soon.

Sorry file was too large for an attachment