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 |
|
enrico
Starting Member
5 Posts |
 Posted - 2009-02-16 : 23:43:14
|
| if my form consists of two tables(namely: tblClient and tblResult) which are connected through a ClientID. how do i save the data in tblResult that will be link to the data in tblClient which was inputted in my form? |
|
|
timmy
Master Smack Fu Yak Hacker
1242 Posts |
Posted - 2009-02-17 : 17:10:27
|
| Can you explain a bit more on what you're trying to do?Ideally you would include a sample of the data that sits in these tables so we can get an idea of the data structure.Cheers,Tim |
 |
|
|
enrico
Starting Member
5 Posts |
Posted - 2009-02-18 : 23:38:58
|
| these are my tables:tblClient ClientID - PK, autonumber Lastname Firstname MItblInfo InfoID - PK, autonumber ClientID InfoA InfoBtable tblInfo is connected to table tblClient through "ClientID". i created a form via design view that consists of the two tables. i know the INSERT statement to be used to save my data. the problem is i don't know how to insert the "ClientID" of the data i just input from table tblClient to tblInfo. |
|
|
|
|
|
|
insert statement