Posted by anasttin on 02/01/06 02:24

Hi,

I need to set up a generic table in Oracle that allows users to enter
data that can later be retrieved in reports.

I was thinking of a 3 column table in this structure:

DATE,ITEM,VALUE

figuring that you can store anything in this way because ITEM can be
anything and you can have multiple instances of a particular value by
having a new date.

Does that seem reasonable?

In any case, what are my user front end options? I was thinking a
Microsoft Access database but its not ideal because not everyone here
has Access?

Can you do it with Excel? Or what other options are there as a simple
user front end to enter the data?

Thanks for any advice.

Kim

• Next in forum: Re: How to find first not null value in column
• Prev in forum: Re: moving tables
• Thread view: front end options for entering data into an oracle database

[Reply to this message]