Forums

This topic is locked

Please help on complex insert

Posted 20 Apr 2001 15:56:10
1
has voted
20 Apr 2001 15:56:10 e site posted:
Hi UDers,

I have to do a complex insert record behaviour like this:

MY ACCES DB STRUCTURE:
I have a "works" table, a related "devteam" table and a related to the "Devteam" "developpers" table.

THE FORM:
The form allows you to fill in all "Work Details" and select which developpers work on it.

THE PROBLEM:
I can add all work details in the "Work" Table, but how can I at the same time create multiple lines to "Devteam" record.

The "Devteam" is a table with records like:
work1 ; man1
work1 ; man3
work2 ; man2
work2 ; man3
work3 ; man1
work3 ; man2
...

So in the end I 'd create one new "Work" Record and multiple "Devteam" records bound with the Work_Id.

Hope this is clear and hope someone can help!

Thanx

e_site




Replies

Replied 20 Apr 2001 17:51:26
20 Apr 2001 17:51:26 Waldo Smeets replied:
I suggest you have a look at the ultradev section at charon.co.uk . There are lots of cool sample pages for download at his site. You've got to check them out and learn a lot from them.

Waldo Smeets - www.UDzone.com Webmaster
------------------------------------------
www.UDzone.com : A dynamic Dreamweaver,
Ultradev and Fireworks site for developers
by developers.
------------------------------------------

Reply to this topic