Hi. Please initially accept my ignorance regarding my understanding of Forms & SubForms (or actually queries & subqueries). As I understand, one of the number-1 rules in Database Design is NEVER to have the same Field (fld) in more than one Table (tbl). Although I know this as a Database rule I greatly struggle with avoiding, knowing that I’m only A) creating more work for myself & B) creating more margin for error. I also have had no luck in joining tbls AutoNumber for my Primary Key (PK), but rather use 1-common (data) fld that enables me join 2 (or more) tbls together based on a common (data) flds between multiple tbls. The issue/problem I’m encountering is have & doesn’t allow me to do any editing within this query (joined by 2-tbls). Allow me to attempt to give an example of what I’m trying to explain: The database is a Music Library Database which has varies Tbls, but we’ll focus on 2-Tbls:
Table:1: Music_Info_tbl
-ArtistsID
-ArtistsID_Name
-Genre
-DUP (Days Usually Played)
-DyEvn: (Day time or Night time)
Table 2: Music_Libray_tbl
-ArtistsID
-AlbmnsCDS: Albums (or CD’S) names
-RD: Release Date
-RcrdLbl: Record Label
If ii were to create a Music_Library query (or actually a Form) based on ‘ArtistsID’ I wouldn’t be able to make any edits.
It’s very frustrating for me because I need to be able to add new data. My thread might be confusing, but I anyone has any
ideas/suggestions would be greatly appreciated.