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...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.