Re: Newbie - dynamic field value generation

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/extinfo/certprog/oad/oad_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)