(n00b) My first lookup table !

(n00b) My first lookup table !

El Forum
Guest

#10

07-07-2009, 10:08 AM

[eluser]Samuurai[/eluser]
I've got issues with this approach...

It will be really messy to insert using multiple lines because it will be 5 steps in total !

I first need to insert the device
Then insert the outage
then query the device table for the device id
then do the same for the outage id,
then insert the id's into the lookup table.

Is this the only way to do it?

Messages In This Thread

(n00b) My first lookup table ! - by El Forum - 07-07-2009, 05:18 AM

(n00b) My first lookup table ! - by El Forum - 07-07-2009, 05:29 AM

(n00b) My first lookup table ! - by El Forum - 07-07-2009, 05:31 AM

(n00b) My first lookup table ! - by El Forum - 07-07-2009, 07:14 AM

(n00b) My first lookup table ! - by El Forum - 07-07-2009, 07:15 AM

(n00b) My first lookup table ! - by El Forum - 07-07-2009, 07:21 AM

(n00b) My first lookup table ! - by El Forum - 07-07-2009, 07:31 AM

(n00b) My first lookup table ! - by El Forum - 07-07-2009, 08:25 AM

(n00b) My first lookup table ! - by El Forum - 07-07-2009, 09:39 AM

(n00b) My first lookup table ! - by El Forum - 07-07-2009, 10:08 AM

(n00b) My first lookup table ! - by El Forum - 07-07-2009, 10:11 AM

(n00b) My first lookup table ! - by El Forum - 07-27-2009, 07:49 AM