(How) Can this be relationship be done?

[Jason Feinberg]

Hi Everybody,

Setting up a database for my marketing company. We need to keep track of projects, websites we've marketed to, last contact status, etc.

I am trying to decide what is the best way to go about this.

I have a MASTER database with info about all the websites we work with. Full contact info, etc. I only want to change THIS COPY if a website record needs updating.

I want to be able to have an individual database for each project, that contains the relevant subset of websites from the MASTER list, as well as specific entries about each website (notes that relate to the website's involvement in the individual PROJECT).

So - is this possible - Have a database for each project. When I am browsing the layout, I can see the list of websites we have marketed to (the subset of the master list), and have a place to input notes, contact status, etc... The challenge here is that the notes/contact status/etc have to be stored somewhere, linked to the websites. But they cannot be stored in the MASTER list, as the notes will be specific to each project.

Wow, I hope that makes sense. I feel like it is a simple problem that I am making complex. Just need to figure out the relationships between the individual projects and the master list of websites.

Thanks!!

Jason

[Wim Decorte]

"subset" doesn't sound good if you mean actual copies of the data. And I would advise against a separate database (= file or table) for each project. All projects belong in one table, related to the other relevant data stored in different tables by projectID.

I think you need:

- a websites table

- a contacts table

- a projects table

- a notes table

Probably all in one file to make it easy.

[Jason Feinberg]

And I would advise against a separate database (= file or table) for each project.

I think you need:

- a websites table

- a contacts table

- a projects table

- a notes table

Thanks so much for your reply. I was in a bit of hurry, hence the less-than-ideal approach, but I agree that it should all be in one database. I've taken this approach and have made progress, but have one question left -

I have (in the same database) a master list of websites, and then want to create the "Notes" table which allows me to make project-specific notes for each website in the project. I have assigned each website in the master list a SiteID, and the notes table will also have the SiteID as well as the different note fields.

Question is this - I can do a Find on the master list and pull up the set of websites I want the project to reference. How do I then get those SiteIDs into the Notes table as individual records? Is there an easier way than doing an export and import?

Thanks,

Jason