Re: Table Structure

I would think that you would have ONE table - ServiceSuppliers - that had a
field to identify whether the entity was a Consultant, Vendor, or
Contractor. I would think that the three types of ServiceSuppliers would
have many (maybe most) fields in common.

ServiceSuppliers
SupplierID
SupplierName
ContactFirstName
ContactLastName
SupplierAddress - Multiple fields
SupplierPhone - If you need a lot of different phones, this may involve a
new table.
SupplierTaxNumber (Taxpayer ID, SSN, etc)
etc.

--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..

"Justine" <justine.thorpe@xxxxxxxxx> wrote in message
news:1170259919.115876.125110@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Hello,

I am reconstructing a database I built a short while ago (not very
good). The purpose of the database is to track construction projects
and all costs associated with each project. Currently I have many
tables, but my concern right now is three tables I have:

ConsultantInfo, ContractorInfo, and VendorInfo

Whenever I send an approved invoice to our finance department for
payment I enter the invoice into an invoice tracking form. The costs
are then associated with the project. My problem is that we make
payments to consultants, contractors, and various vendors that are
neither consultants or contractors. I need to have a table to collect
contractor and consultant information (each set of information unique
from the other) so therefore the two tables. What I currently have
set up is redundant - I also have a vendorinfo table that contains
vendor (non consultant/contractor) information, as well as all the
contractors and consultants. I then use this table as a combo box in
my invoice tracking form.

Does anyone have any suggestions for what a better approach might be?
I thought about creating a query that contains the names from all
three tables and then creating a subform (which I don't really want to
do)based on the query to put on my form...Any suggestions??

Thanks in advance for any insight

Justine



.

Relevant Pages

  • Re: Table Structure
    ... I would think that the three types of ServiceSuppliers would ... neither consultants or contractors. ... vendor information, ...
    (microsoft.public.access.gettingstarted)
  • Re: Table Structure
    ... for Contractors and Consultants to hold the fields that apply only to them. ... That way you can get all service suppliers from one table and if you need ... vendor information, ...
    (microsoft.public.access.gettingstarted)
  • Re: Table Structure
    ... for Contractors and Consultants to hold the fields that apply only to them. ... That way you can get all service suppliers from one table and if you need ... vendor information, ...
    (microsoft.public.access.gettingstarted)
  • Re: Tunnelling via SSL anonymously to connect to remote host(s)
    ... > You then talk to some other consultants and they ... >> timesheets when he knows that the contractors are flying back to ... Define "trail stops". ... An alternative would be to purchase cash-only accounts at an ISP too stupid ...
    (comp.security.ssh)
  • Re: NBC And they thought Ferraro was racist?
    ... contractors, who are men, women, gay, Mexican, Korean, Indian, Indonesian, Portuguese, Italian, French, Swedish, Australian. ... 10 girls and *probably* pays them $5/hour. ... If I could find consultants who know the software I work with *for ANY price* in the US, ... You see, this software company was originally a Swedish company, expanded throughout Europe, Australia, and shortly after they opened offices in the US, bush's first recession hit, and so they had just started recruiting and training here. ...
    (rec.music.artists.springsteen)
Loading