Hello,

I thought I'd hit up the Oracle gurus in the crowd to seek any assistance
and/or strategies on approach.

I have one table with straight forward static tasks (not a problem). Now I
want to build a table that can generate a task on-the-fly. For instance,
the number of CPUs scheduled for installation would change depending upon
the office location that the task is scheduled for. The number would be
pulled from another inventory table based on the office location id.
Ideally I could have multiple office locations scheduled to implement the
same task, yet the task displays correctly based on the office scheduled.

id_cd, tsk_nm_txt, tsk_dsc_txt

id#, Task Name (Install x CPU(s)), Task Description

100, 'Install x CPU(s)', 'Any description will do.'
101, 'Install x Laptop(s)', 'Any description will do.'
102, 'Install x Printer(s)', 'Any description will do.'
103, 'Install x Hub(s)', 'Any description will do.'

Thanks and appreciation in advance,

Toney.....

Toney wrote:

> Hello,
>
> I thought I'd hit up the Oracle gurus in the crowd to seek any assistance
> and/or strategies on approach.
>
> I have one table with straight forward static tasks (not a problem). Now I
> want to build a table that can generate a task on-the-fly. For instance,
> the number of CPUs scheduled for installation would change depending upon
> the office location that the task is scheduled for. The number would be
> pulled from another inventory table based on the office location id.
> Ideally I could have multiple office locations scheduled to implement the
> same task, yet the task displays correctly based on the office scheduled.
>
> id_cd, tsk_nm_txt, tsk_dsc_txt
>
> id#, Task Name (Install x CPU(s)), Task Description
>
> 100, 'Install x CPU(s)', 'Any description will do.'
> 101, 'Install x Laptop(s)', 'Any description will do.'
> 102, 'Install x Printer(s)', 'Any description will do.'
> 103, 'Install x Hub(s)', 'Any description will do.'
>
> Thanks and appreciation in advance,
>
> Toney.....

I have no idea what it is that you want. But it certainly seems from your
description that you need to get a good book on relational databases, Cobb's
rules for normalization, and database design. Check with a local college or
university.

--
Daniel Morgan
http://www.outreach.washington.edu/e...ad/oad_crs.asp
damorgan@x.washington.edu
(replace 'x' with a 'u' to reply)