advice for table fields

[cjharley]

I am creating a database to track progress on my Projects and I need a bit of advice on what way to create the tables etc...,. The Projects will have difference phases "phase 1,2,3,4 etc...," with loads of contacts involved ie Engineering Consultants, Project Managers, Contractors, Government Departments etc...
I am creating a table that is a phase progress table and I want to be able to create an email, letter, Set a task in the calender, grab an email from outlook.
The contence added into "Textural Description" I would like when I pick a "new Comment" button an dialog box comes or it opens word to put the comment in. The Outcome will be either email, letter etc or no further action.
Is it possible to have email, letter, Calender item, Reminder, or "no Further action as a pull down List.
What way would anyone recommend I do This, I can attach the database if someone is willing to help me through the database, I looking for advice and help.

I have uploaded an image of the phase progress table.

 

[CJ_London]

the fact you have a field called 'phase name' which is a number type implies you have set this up as a lookup. Recommend you don't, it will only cause confusion both to yourself and to those trying to help you.

With regards your actual question, I'm struggling to understand what you require - but it sounds like you need a combobox with a value list

 

[cjharley]

What i am looking for is
what would b the best way to do deal with the outcome option
any idea?
Just have a row of buttons and a field showing outcome ie after picking email button, a note is put in the field ""emailed""

 

[CJ_London]

just a bit of code in the button on click event

myfield="Emailed"