[program-l] dataBase Question
- From: "Mick Saltzman" <smickie@xxxxxxx>
- To: <program-l@xxxxxxxxxxxxx>
- Date: Wed, 4 Mar 2009 17:26:17 -0800
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:
