Problem appending data to a Table

[ghettosega]

Hi There

I am trying to create a table that will join two tables together making it a many to many relationship. I have one table called "File" this table has all the attributed accociated with the file and i have a "Group" table where i have all the attributes with the group but in the "Group" table i also have the FileId field showing all the files that group belongs to. How can I create a table which takes all the files and all the groups connected to those files in one table

Thanks

-Sega

 

[Ziggy]

Make a "JOIN" (select)query by putting both tables into the design view and drag a link between the related fields. Right click on the line to see join options, if access automatically put in a join (because of relationships)and it is not the one you want make sure you delete it.

This query can be used for forms/reports