
July 6th, 2006, 08:15 AM
|
|
Registered User
|
|
Join Date: Jul 2006
Posts: 1
Time spent in forums: 22 m 23 sec
Reputation Power: 0
|
|
Linking Tables
I have 4 tables
tblmake
MakeID (pk)
Make
tblModel
ModelID (pk)
Model Number
MakeID
tblInk (pk)
InkCartID
ModelID
tblInkTest
InkCartID (pk)
Ink
Price
Stock
and have linked them together with relationships using the forign keys. Only trouble is when i either add a new model or ink they do not get updated in the tblink and have to be manually typed in. Anyone got an idea on how this can be resolved? thanx in advance!
|