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 |
MTSPEER
Starting Member
6 Posts |
Posted - 2013-06-04 : 11:14:36
|
I have to create a form with entries like member name, ID number, Contact Phone, fax. And I want to add a combo box. But I have no data. I want to create the form. and each individual record i make in the form I want it to save the data in a table. Is that possible? Do I make fields first in a table then create a form? I tried that, and whenever I create the first record then go to the next one the same infomration is kept for the next form which I dont want. The combobox information stays the same for every recordAnd I Want to keep the Phone Number and Fax the same for every record |
|
MIK_2008
Master Smack Fu Yak Hacker
1054 Posts |
Posted - 2013-06-04 : 11:35:52
|
I belive this is more related to application development, may be you can have best answers from a relavant appliaction development forum e.g. .Net/Php/java etc forums To that end, what I can answer/suggest is 1)I want to create the form. and each individual record i make in the form I want it to save the data in a table. Is that possible?Yes it is possible. 2)Do I make fields first in a table then create a form?Thats upto you .. whichever you want to create first (ideally the DB and tables should be first). But one thing for sure, before clicking "Save" button, the table must exist in the database. 3) I tried that, and whenever I create the first record then go to the next one the same infomration is kept for the next form which I dont want.you'll need to write the application code accordingly4) And I Want to keep the Phone Number and Fax the same for every recordSame answer as that of 3.CheersMIK |
 |
|
MTSPEER
Starting Member
6 Posts |
Posted - 2013-06-04 : 11:44:36
|
Okay, with all that information you gave me, it didn't help me figure out how to solve it. |
 |
|
|
|
|