[program-l] Re: dataBase Question
- From: "Mick Saltzman" <smickie@xxxxxxx>
- To: <program-l@xxxxxxxxxxxxx>
- Date: Fri, 6 Mar 2009 19:34:42 -0800
Hello George, I should explain that I came down with some kind of virus myself,
so it's been a while since I've done anything with my computer, so I'm still
catching up on my e-mail. I guess I should have went into more detail about the
database. With the One Author many books relationship, the Author Id is the
primary key in the Author table, and there is an Author Id field in the Books
table so I can complete the relationship. The other one to many relationship is
the one series Many Books with the Series Id field as the primary key. As far
as the error message it says basically can not save record because the table
series is related to it.
----- Original Message -----
From: George Bell
To: program-l@xxxxxxxxxxxxx
Sent: Thursday, March 05, 2009 2:12 AM
Subject: [program-l] Re: dataBase Question
Hi Mick,
The answer is in the primary key of the secondary (Author's Books) file.
(Which hopefully is the same as the Author details table) You perhaps have two
choices here. Create a secondary key in this file using perhaps the ISBN
number, which in turn would make each record unique. Or, you could allow
Access to create it's own key, which would essentially end up being a
sequential number.
You then need to create a Books sub-form to display books by a selected
author using the author file with a one to many relationship to the Books table.
I could explain this a lot better if I had Access 2003 available to me right
now, but some idiot (me!) has Access 2007 on his system, and somehow have
completely lost the plot with that version. I can get on one later if needs be.
George.
From: program-l-bounce@xxxxxxxxxxxxx [mailto:program-l-bounce@xxxxxxxxxxxxx]
On Behalf Of Mick Saltzman
Sent: 05 March 2009 01:26
To: program-l@xxxxxxxxxxxxx
Subject: [program-l] dataBase Question
Hello folks, I have a database question that might seem simple for most of
you, but I'm having a hard time figuring out what to do. I'm developing a
database for a friend. It contains information on books. My problem concerns
the 2 1 to many relationships. One Author many Books, one series many books. My
problem has to do with not binging able to enter data into my one author many
books form because Access won't let me save the record do to the fact that I
have the related series table. I do have a form, and sub form one series many
books, but my question is is there a way I could create a form that would allow
me to add a record that would include the authors, Books, and series. I am
wondering if I might have to change the relationships so that it uses only the
author table as the one part of the relationship on both relationships. I
should also mention I am using MS Access. Any help would be grate.
Thanks.
Mick
Other related posts:
