scottappleford
Registered User.
- Local time
- Today, 04:40
- Joined
- Dec 10, 2002
- Messages
- 134
Hi all
forgive my lack of knowledge but is the idea of a db to reduce data entry? If I had 3 tbls for the following, i would only need to enter the box number once. I have come up with the following what do you think as I still have one problem.
tbl 1 tbl2 tbl3
contract no (pk)1 many Contract no (pk)1 many Contract no(pk)
conract details.... Box no (pk)1 many box no(pk)
item no (pk)
contents
The only problem is when I enter contract no in tbl 1 it updates tbl 2 and 3, however when I enter box number in tbl 2 it does not update tbl 3, why is this, because if it updated the db would work fine, as it will prevent duplicates and data entry, ie. what my understanding of a normalized db is.
I have referential integrity and cascade update ticked?
I really appreciate your help.
thanks
scott
forgive my lack of knowledge but is the idea of a db to reduce data entry? If I had 3 tbls for the following, i would only need to enter the box number once. I have come up with the following what do you think as I still have one problem.
tbl 1 tbl2 tbl3
contract no (pk)1 many Contract no (pk)1 many Contract no(pk)
conract details.... Box no (pk)1 many box no(pk)
item no (pk)
contents
The only problem is when I enter contract no in tbl 1 it updates tbl 2 and 3, however when I enter box number in tbl 2 it does not update tbl 3, why is this, because if it updated the db would work fine, as it will prevent duplicates and data entry, ie. what my understanding of a normalized db is.
I have referential integrity and cascade update ticked?
I really appreciate your help.
thanks
scott
