Hovedkategori liste som i Outlook.

Without knowing little at all about your requirements I cant b e100% sure, but I would very much thnk it is possible.

You will need three tables (many-to-many relationship)
One table contains persons, another "muligheder" and the last is a link table which contains the realationships between person and "muligheder"

Yes this strukture I am aware of, but how do I present this to the users in a form for input, and it has to be dynamic, so the user can ad "options" (options = muligheder).
I think I just had the idea, pupping up in my head. I have to use a form with a subform!!

Jeg er forsåvidt enig i n-m strukturen. Men afhængig af størrelse m.v. kan det være overkill. Som jeg forstår det, kan person vel indeholde een person een gang. Herved kunne du nøjes med 2 tabeller person og muligheder. (og der med en 1-n relation). Databasen ville stadig være normaliseret.

Og ja - subforms ville jeg også vælge.

madschristensen> If you want to have many options for each person where are we to have these relationships?
A person can have MANY options and a single option can be related to many persons!

If you know for sure that a person is only to have ONE option then YES two tables is enough, but of a person can have MANY options then you need three!

chilly....> You will need a main form for the person information and then a sub form which actually is the MIDDLE table which contains the relationships to Person+Options. Then the options is a combo box where you can choose the options you want to attach to a person. There is an event NOT IN LIST on a combo box, and you can use this to add further options, and if necessary (depending on how many fields you want in options) you can open a form for creating new options.

chilly.. can you give some feedabck please, its easier to help that way.
thanks!

sorry I have been very busy.
regarding the tables I belive the solution has to have 3 tables because as you state a person can have MANY options.

regarding the forms I again stick with your solution, but I belive that the combo box cannot add options to the options table?

Have you looked at the NOT In LIST event?

http://www.mvps.org/access/forms/frm0015.htm

nop, have to much work, I shall be back, as Arnold states!

Asta lavista baby!

og god weekend :o)

How it going here chilly?

chilly .. can we close this question please?

thanks chilly, if you nee help on the Q at a later date then just drop a comment.

mvh
Terry