Please Suggest for this non relational design

[vikjai]

HI all,

I have to desing a database in access for HRD Department of a
company.. and here the problem is that they want a facility so that
they can increase the columns of the Employee table with it's data
type... same as one can do in MS Excel ..Because somtimes there
central body ask them different thing of which they have no idea.

I know this will make data base no more relational..

what i have thought of structure like this

Employee(
ID, <-- uniq id
Name
:
:
:
)

Then there will be one More table which will have one to many
relationship with Employee table and
Columnname(
id
Colname
)

Others(
EmpID, <-- fkey to Employee.ID
Data
Columnid <-- fkey to Column.id.ID

)

but in this type the datatype can only be text and has to be fixed ..

there is one more option is to increase the columns dynamically and
will not help in serching and reporting ...

reply please if someone have any suggestion ..

Thanks in advance..

viks

[Pieter Linden]

Let them create a separate table where they can add all the fields
they want. Then create a PK of the same type as the original table.
Create a outer joined query between this and the main table and they
can get all the information they want.