Help with database structure

[Guest]

Good Morning! I'm having trouble trying to get my mind around a database I
have to design for my boss, hopefully you guys can help... the structure is
stumping me as I haven't used Access in years. Here's my issue:

We have projects, and for each project we send a bid to multiple people. If
our bid is accepted, then the project becomes a job for us and we will begin
invoicing, with perhaps multiple invoices per job.

What I don't understand is how to set the tables up so that if a bid is
accepted then that quote becomes a project and I begin invoicing from it. Do
I have seperate tables for the quote and the project? Not all quotes will be
accepted, not all will become jobs. And if seperate tables, then how do I
move the information from quote to project if the bid is accepted?

Clear as mud? Thanks for any help you can provide

Kim

 

[Guest]

In the Bids table add field ProjNum. Use this same field in the Project
table. There is no need to move your data - it is accessible through a query.

 

[Jeff Boyce]

Kim

A bit more description of the data and relationships would help me
understand your situation.

As a general discussion, if the information you include in a "bid" (for a
?prospective project) is the same information (or close) to what you use if
the bid is accepted, then your situation may not require separate Project
and Bid tables. Instead you may be able to add an Accepted(y/n) field to
your Bid table.

For more specifics, provide more specifics!

Regards

Jeff Boyce
<Office/Access MVP>