Setting Up A New Db

Hi Guys,

ok I work a lot on databases but have recently been asked to set up an access database for my team. We are a marketing team within a large insurance company and need a small access database for MI and project management.

I have made a start on this and going well so far but there are some things I need it to do that I dont know how :P

Ive never messed about with Acess before so bare with me :P ok so this is what im looking for, any help would be greatly appreciated.

I have set up various tables for look up wizards for some of the menus on another table I designed for the raw data entry.

I need two tables, two forms - one table for very basic generic data such as

- Job Number
- Description
- Business Unit
- Owner
- Due Date
- Completion date

I then need to drill down into this to add more information, so its basically two tables on top of each other with co-dependencies.

So for example one of my team enter a new project at the very basic lvl, they have a job number, they know what business unit it is for and they know the date its due, as time goes by and work is done on the project I want them to be able to click on a button that takes them to another form where they can enter information that is linked to the original information.

So they search for job number 00000 and come up with the above data on the first form, I want them to then click on 'Project Information' button and be taken to another form that has a lot more stuff on there, like a description, complications, notes, links to documents etc etc. I tried to do this linking two tables together but it doesnt work as the two forms/tables are not co dependend and are irrespective of each other.

Does this make any sense ? and does anyone know how I might make this work ? Please let me know if I am not clear and I will try to explain as best I can

I would also like to change the form 'theme' aswell and have my companies logo transparent behind the data fields etc, anyone know how to do that as I only have the option to use the standard themes.

Any help would be greatly appreciated

Sleek