Search results for query: *

Thanks JonFer, Your approach is much clearer, even if there are more queries. I tried to run the qryAllTypes and I still get the system resource exceeded error. Any ideas as to what causes this or how to get around it?

Leslie, I made the changes you suggested, except I left writers and editors separate. I still have two integrity issues. 1. When I join tblWriters with tblArticle on WriterID, I can't enforce integrity. 2. Joining tblClients with tblArticleClient on ClientID creates a 1:M with integrity, but...

Thanks for the quick response! Editors are bound to the Publication, but writers are not.

Richard, Thanks for your help. Hope this thread is still alive. My attention was demanded elsewhere. Back to the design. I have the following tables: tblPublications PubID fields for contact, rates, etc. tblWriters WriterID FN LN tblEditors EdID PubID FN LN tblClients ClientID Name Contact...

I would like to catalog magazine articles. Fields are: Publication, Date, Author, Editor, Keywords. How do I best handle the physical article? Scan to a library directory and create a filename field in the table? Can a report field contain a shortcut to the article? Or, do I copy and paste the...

TheAceMan1, Re: your post of 5/22. I have a cbx with 3 columns, ID, FN, and LN. ID is hidden (0 width). Can this be done to update both FN and LN? Thanks in advance, EB

Thanks Willir, I see now. Create tblArticle like this: tblArticle ArticleID - primary key PubID WriterID EditorID ClientID Title Date Then I can create a form with 4 combo boxes populated with records of the foreign keys. NotInList can trigger appropriate forms to enter data in the foreign key...

I have 7 tables: pub, writer, editor, client, articles, pub group, adreps. Each has an autonumber primary key. Of the 42 relationships between them, 12 are one to may, but 30 are many to many. I want to query all combinations of clients, pub, writer, editor, and article. Also, all combinations...