|
ausmoran -> Entering Data Into Three SQL Tables (6/20/2007 8:56:49)
|
I am completely new to DW (MX 2004) and am in need of someone's assistance. I have created an asp page in which I have a simple form that allows users to enter demographic data that will be stored in the VOLUNTEERS table. I also need to provide a mechanism for those same people to enter data in the COMMITTEE_VOLUNTEERS table. This Committee_Volunteers table contains primarily checkboxes (BIT) for various committees that volunteers may join, along with several other VARCHAR type fields. Some of the data for the COMMITTEE_VOLUNTEERS table is linked from a COMMITTEES table (this table stores a list of committees, and term).
Do I need two separate asp pages in order to provide a simple mechanism for users to enter and submit data to my SQL database? Or can I create a Stored Procedure in which I join all of the tables and then use that as the underlying data source for all of the required fields?
As I said, I am very new to this so am not really sure which way to go.
Thanks ever so much (in advance),
-Austin
|
|
|
|
