Here is my database design:
Entity
------
Publisher([PubCode], PubName)
Author([AuID], AuName)
Sale([BkCode], Price, UnitOnHand)
Book([BkCode], Title, BkType, PubCode)
Relation
--------
Edit([BkCode], [AuID])
When I create a input form by wizard, I use
Publisher([PubName)
Author([AuID], AuName)
Sale(Price, UnitOnHand)
Book([Title, BkType, PubCode, BkCode)
as my selected filed...
When I open the created form, a automatic Record slider is at the
bottom. When I want to create a new record... error occurs... saying
that...
You cannot add or change a record because a related recrod is required
in table "Book"
What should I deal with this problem?
Here is the relationship:
Author 1 - many Edit (Cascade update)
Book 1 - many Edit (Cascade update, delete)
Book 1 - 1 Sale (Cascade update, delete)
Publisher 1 - many Book (Cascade update) 1 1342
hello,
"faiyeah" <fa********@gmail.com> wrote in
news:11**********************@u72g2000cwu.googlegr oups.com: Here is my database design:
Entity ------ Publisher([PubCode], PubName) Author([AuID], AuName) Sale([BkCode], Price, UnitOnHand) Book([BkCode], Title, BkType, PubCode)
Relation -------- Edit([BkCode], [AuID])
Very good structure. We'll now look at the relations (moved from
below.)
Here is the relationship: Author 1 - many Edit (Cascade update) Book 1 - many Edit (Cascade update, delete) Book 1 - 1 Sale (Cascade update, delete)
I don't think one to one here is good. You may make many sales
of copies of one book. one to many is preferred.
Publisher 1 - many Book (Cascade update)
When I create a input form by wizard, I use
Publisher([PubName) Author([AuID], AuName) Sale(Price, UnitOnHand) Book([Title, BkType, PubCode, BkCode)
as my selected filed...
When I open the created form, a automatic Record slider is at the bottom. When I want to create a new record... error occurs... saying that...
You cannot add or change a record because a related recrod is required in table "Book"
What should I deal with this problem?
When creating a new record, you violate the referential
integrity in the query that the Wizard has created in the form.
Easy fix. create the form using only fields from book. Use
comboboxes to populate bkType, PubCode. Make a separate form for
entering the info to the Edit table. Note that edit is a
reserved word in access and you may encounter situations where
ACCESS gets confused.
Make a separate form for entering sales info, again using
combobox for the BkCode Here is the relationship: Author 1 - many Edit (Cascade update) Book 1 - many Edit (Cascade update, delete) Book 1 - 1 Sale (Cascade update, delete) Publisher 1 - many Book (Cascade update)
--
Bob Quintal
PA is y I've altered my email address. This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: Sergio Otoya |
last post by:
Hi all,
I need to add an input hidden field to an existing form (post).
I have tried a couple things like adding the '<INPUT type=hidden
name=idSelectedURL value=http://server/documents>' to...
|
by: Wescotte |
last post by:
I'm writing a tiny php app that will log into our bank of america
account and retrieve a file containing a list of checks that cleared
the previous day. The problem I'm running into is when I...
|
by: Doug Thews |
last post by:
I'm writing some sample threading code, and have already got many examples
working that look a lot similar to the ones mentioned here. What I'm seeing
is that most people put their method that...
|
by: Calvin Lai |
last post by:
Hi all,
I have a problem in creating web user control *programatically*. Problem as
follows:
1. WebUserControl1 contains a server side table named Table1
2. WebForm1 contain a server panel...
|
by: GTi |
last post by:
I want to use a 'smarter' checkbox using span. When a user press the
text the checkbox is checked. But this dos't work as expected. Any
idea?
<span style="cursor:pointer;"...
|
by: ged |
last post by:
Hi,
i am a oo (c#) programmer, and have not used javascript for a while and
i cant work out how javascript manages its references. Object
References work for simple stuff, but once i have an...
|
by: mjsterz |
last post by:
I've been working with VB .NET for less than a year and this is the
first time I've posted on one of these groups, so let me apologize
beforehand if I'm being unclear, not posting my issue...
|
by: Radu |
last post by:
Hi. I am creating a user control in vs2005 which is supposed to provide
a fancy gradient background - in theory, you just drop it on a form,
you set the start/end colors, the gradient type, and...
|
by: w |
last post by:
Hi,
I'm trying to use ASP to write XML documents form input from a HTML form.
I have to write some tags like this:
<creation audience="internal">Written in
<date></date>by using guideline...
|
by: =?Utf-8?B?UHVjY2E=?= |
last post by:
Hi, I'm using VS2005 and .net 2.0. I'm creating an application that has 3
forms. I want allow users to move forward and backward with the forms and
retain the data users have entered. I thought...
|
by: DolphinDB |
last post by:
Tired of spending countless mintues downsampling your data? Look no further!
In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
|
by: ryjfgjl |
last post by:
ExcelToDatabase: batch import excel into database automatically...
|
by: isladogs |
last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM).
In this month's session, we are pleased to welcome back...
|
by: jfyes |
last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
|
by: ArrayDB |
last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
|
by: Defcon1945 |
last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
|
by: Shællîpôpï 09 |
last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
|
by: af34tf |
last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
|
by: Faith0G |
last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
| |