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 |
|
Gemini23
Starting Member
1 Post |
 Posted - 2010-12-18 : 10:23:48
|
| Hello,I'm relatively new to SQL and am currently moving an Access DB across to MS SQL and creating a front end in a piece of web application building software called CodeCharge Studio.The DB is a Project Logging and Tracking system with major tables including Client, Projects, Engineers. I would like to be able to autopopulate a field based on the client table information.Users can "Create new project", inputting in all required information. Currently they are required to input in the following:Projectname, clientname, sales engineer, designer, datein, projectvalue, discipline, weightingnumber, uk/overseas.I would like to remove Discipline and WeightingNumber and have them autopopulate when a user inputs new project. These fields are from the TblClient, which includes ClientID, clientname, discipline, and weightingnumber. So when a user inputs a new project and they select the clientname from drop down the weightingnumber and discipline will be automatically filled.I can supply more information if needed.Thanks! |
|
|
dataguru1971
Master Smack Fu Yak Hacker
1464 Posts |
Posted - 2010-12-19 : 09:08:27
|
This could be done in the front end, and /or during the final data insert to SQL via stored proc.
Poor planning on your part does not constitute an emergency on my part. |
 |
|
|
|
|
|
|
|
Autopopulate field