Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
rgssanchez
Starting Member
2 Posts |
 Posted - 2005-12-13 : 11:57:15
|
| I am brand new to SQL Server 2000 and have encountered an issue. I created a DB with 5 or so tables all of which contain different client information. All tables are related via the Client_ID primary key I set in my main table, and foreign key in all the subsequent tables. Im using a Microsoft Access Project form as the front end.Im having trouble figuring out how to populate the subsequent tables with the Client_ID after a enter the data in the Main table where the primary key resides.Do I create a trigger or a stored procedure...am i even in the ballpark?thanks in advance. |
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2005-12-13 : 12:40:26
|
| Sounds like you are trying to "Prepopulate" tables with a key, even though you don't have data.This is not a good idea.Do you have SQL Server client tools installed?Do you have books online?You want to look up SCOPE_IDENTITY.And if you're new to sql server, I would suggest that every data source be unbound and only use strored proceduresBrett8-)Hint: Want your questions answered fast? Follow the direction in this linkhttp://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspxAdd yourself!http://www.frappr.com/sqlteam |
 |
|
|
rgssanchez
Starting Member
2 Posts |
Posted - 2005-12-13 : 15:23:50
|
| I have Books online installed, I dont have SQL Server client tools installed.Im not sure if im trying to prepopulate, but I need all client records to be complete. As of now when I attempt to enter a record the main table keeps the information all the other tables dont keep the information I entered. |
|
|
|
|
|
|
Updating Foreign Keys