473,320 Members | 1,863 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

Problem in form creation~

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)

Apr 1 '06 #1
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.
Apr 1 '06 #2

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

8
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...
6
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...
7
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...
3
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...
16
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;"...
6
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...
0
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...
2
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...
7
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...
14
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...
0
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...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
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...
0
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...
0
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...
0
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
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....
0
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
0
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...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.