Relationships and call management

[Guest]

I am trying to put together a bid management database which tracks what jobs
we bid and who we bid the job to (we sub bid supplies to contractors who are
bidding construction jobs so multiple customers bid one job we bid the
materials to these multiple companies (sales opportunities are job based and
not customer based, else I would use Outlook.)) I created a *jobs* table,
*companies* table, *contacts* table, *items* table, *items on job*, these I
understand a little but here are the ones I have trouble with:
-*bidders on job* (related to companies and contacts and jobs.) I want the
drop downs in my forms to select only contacts related to the companies.
-*calls* to bidders (I can either relate the calls to the *bidder on job*
(a separate table from customers and contacts.) or related it to the jobID,
companyID, and contactID. I just don't know and this is where it starts
getting confusing.

I wonder if I am in over my head...

 

[Jeff Boyce]

Take a look in Access HELP, at mvps.org, or search at Google for "cascading
combo boxes". This is the term used to describe limiting what's shown in
one combo box, based on what was selected in an earlier combo box.

Regards

Jeff Boyce
Microsoft Office/Access MVP