azzarev
Posts: 9
|
| Posted: 06/17/2013, 10:24 AM |
|
Hi Guys,
I have to insert a record in two differents tables. How can I do it? I have no idea.
|
 |
 |
adorni
Posts: 120
|
| Posted: 06/19/2013, 9:40 PM |
|
I need this too.
Thanks!
|
|
|
|
ckroon
Posts: 869
|
| Posted: 06/26/2013, 5:41 PM |
|
Use the record form to insert the record into table 1, then add a Custom Code event to the record from in the After Insert Event.
You need to grab the last insertID from the record you just inserted, get teh values you need from that record and then do a sql Insert into table 2.
_________________
Walter Kempees...you are dearly missed. |
|
|
|
azzarev
Posts: 9
|
| Posted: 06/26/2013, 6:53 PM |
|
Really thx for your reply.
1) How to grab last insertID from the record I just inserted?
2) How to get the values I need from that record?
3) How to do a sql to Insert into table 2?
Sorry but I am totally newbie! Thanks for your patience!
|
|
|
|
MichaelMcDonald
Posts: 640
|
| Posted: 06/27/2013, 7:54 PM |
|
There are a couple of guys on here whose business provides CCS training.
For newbies attempting this kind of thing, it's a good idea to consider them, because they can provide jump starts into complex solutions.
_________________
Central Coast, NSW, Australia.
|
|
|
|
azzarev
Posts: 9
|
| Posted: 06/27/2013, 7:59 PM |
|
Quote MichaelMcDonald:
There are a couple of guys on here whose business provides CCS training.
For newbies attempting this kind of thing, it's a good idea to consider them, because they can provide jump starts into complex solutions.
How to obtain this training?
|
|
|
|
