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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2000-11-11 : 12:16:27
|
lia writes "hello.
First question
how to add multiple data from my form. I'm using checkboxes in my form. let's say i have 4 checkboxes in my form, and the user submit 3 from 4(it means she checked 3 checkboxes). What do my database will lokk like? what data type should it hold? I'm using access, and pws.
second question
i want to make the above submitted data (from the checkboxes) to enter two table automatically. How to do that. as far as i'm concern the data just added to one table only. How to make the data added into two different table. Let me show you my table:
on table A hold the data submitted from the first question.
the expert field can hold more than 4 valuses(from the checkbox in the form)
table A -Id Name expert
table B -Id expert
the two table must have the same Id and expert.If user submit 3 data for expert, so table B must list all the 3 data and also the Id" |
|
|
|
|
|
database