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.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 New Records

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 record

And 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 accordingly

4) And I Want to keep the Phone Number and Fax the same for every record
Same answer as that of 3.

Cheers
MIK
Go to Top of Page

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.
Go to Top of Page
   

- Advertisement -