Traffic Database

[brian873]

Hi,

I am new to access and databases. I have taken on the job of creating a new one form scratch for my company. We are an advertising company and want a system to log, track and search all jobs that go through our traffic and production departments.

I have attached the basic plan for what I think we will need. Can anyone have a look at this and tell me if it looks ok or am I going in the wrong direction. The database will record many different job types with each having unique information in it. I was thinking of splitting these job types in to separate tables but always looking up a value JobsID in the jobs table in order to provide a unique number. And would it be or how would ii go about linking jobs with each other? So one JobID may have more than one job type linked to it ?

Sorry if I have not explained this well but I am trying to learn as I go along.

Thanks brian….

 

[ecniv]

Jobs to type table for the latter part question.
Would hold JobID and JobTypeID.

tblDepartments - check spelling of Depertment field

Clients and supplier tables could be merged with flag to client (Y/N field?) Up to you on that one.
As above for the contacts. (only a suggestion)

Looks like it may work the way you want.


Do you need a Client to job table with the supplier in it?


Vince

 

[brian873]

Thanks for the reply Vince.

Yes, I think I would need this a Client to job table with the supplier in it. Would this cause a problem?

I am still planning it out the best way to do this. And I am now thinking along the lines of each job type having its own table as each job type contains a lot of information relating only to the particular job type. Would it be possible to do this and have a drop down box change a sub form depending on the job type selected?

Brian...