Obp! Help!

Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

MarkAnthonyChesn

Thread Starter
Joined
May 9, 2011
Messages
141
OBP!

I have a new little project! Can you help?

If yes....I am trying to make a small database for contacts, projects, and programmes. I need everything to be interlinked where contacts would also list the projects they participate and the same for projects to list all of the contacts that participate...real vague...I know.

I have attached the tables and some simple forms to get started...

If, no.....please don't say no!

PS. Have you started using 2010??? I cannot seem to save it to an earlier version...
 

Attachments

OBP

Joined
Mar 8, 2005
Messages
19,895
No I haven't started using Access 2010, or even 2007 for that matter.
I can take a look for you but I am going to be busy away from the Computer (Decorating my Son's house) for most of each day from now till Sunday.
If you only save the tables & queries, it should save as or import in to Access 2003 OK.

ps how's the Wine business going?
 

MarkAnthonyChesn

Thread Starter
Joined
May 9, 2011
Messages
141
Great to hear from you! And I hope the decorating is coming along!

We are pushing forward with the Enoteca Hindlian for the next season with strategies for a National Promotional Centre for Bulgarian Wines. Cross your fingers!

As I also work with many EU funded projects from the many EU programmes, I need a small database to collect this information...I should know how to do all this but, I am not a database guru such as yourself!

I will walk through the concept again with a bit more direction:

First I need a Project Partner/Organisation form with a way to list the different individuals from that organisation that have worked on each project. There will be many projects for each Project Partner/Organisation and many differing individuals per project.

I also need an EU Project form that will provide for descriptions, programme, programme year, status, etc. I should be able to reference all of the project partners per project.

I also need the same type of form which describes each EU Programme and also be able to reference projects and participants based on each programme…

I have included the possible tables and a loose structure to the database....

Thanks as always!!!!!!
 

Attachments

OBP

Joined
Mar 8, 2005
Messages
19,895
OK, I have had a look at the tables & Relationships and I have a couple of questions.
The Project table has a ProponentID, but the Proponent table has a ProjectID, which is obviously a "conflict".
I am I correct in thinking that a Project can have Multiple Proponents and a Proponent could be invloved with multiple Projects?
Where does the Liquidations table fit in to the table structure?
Unfortunately you do not use the same words in your forum description as the names of the tables, can you tell me what equals what?
Obviously the Project table is self explanetory, but is a Proponent = Partner/Organisation? etc
 

OBP

Joined
Mar 8, 2005
Messages
19,895
So are "Contacts" = Individuals on your diagram or ProjectPartners/Organisations?
 

MarkAnthonyChesn

Thread Starter
Joined
May 9, 2011
Messages
141
Hey OBP!

So, I was tinkering around...mind you that's all I'm really capable of :)

I separated the Companies from the Contacts...2 tables now because I will have different people from the same company working on different projects. Companies with a one-to-many with projects and a many-to-many with a third table ProjectID & ContactID, plus I placed a one-to-many Programmes to projects...

here is me trying to export again in 2003.....

Failing....I have 5 tables with no information and it is 1.24 MBs?????
 

OBP

Joined
Mar 8, 2005
Messages
19,895
OK, you have created that correctly, it reproduced what I had done when I asked the question, although you now have a Company table as well.
You should do a Compact & repair to reduce the size of the database and then Zip it to put it on here in Access 2003 format.
 

MarkAnthonyChesn

Thread Starter
Joined
May 9, 2011
Messages
141
Hello! I had to create a new database and import all of the tables then save to 2003...anyway, here it is!

I separated the Companies from the Contacts, because one company may have several experts each working on different projects,,,

Please have a look :)

THANKS!!!!
 

Attachments

MarkAnthonyChesn

Thread Starter
Joined
May 9, 2011
Messages
141
I know I am being difficult....no I think that is all with the tables :) unless you have some technical suggestions and/or additions...

THANKS!!!
 
Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

Users Who Are Viewing This Thread (Users: 0, Guests: 1)

As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 807,865 other people just like you!

Latest posts

Members online

Top