Contacts Tables

Hello,

Im designing a database for people responsible for applications at my work.
We have three groups, ApplicationOwner, ApplicationOwnerIT,
ChangeControlContact.

I want all the contacts in one table and linking to the application table as
the appropriate people. I set a join from contacts to the three application
table and it would only force it to one of the groups not all three. I then
created three tables with only one field in each, ID field to act as a
passthrough table from contacts to applications but thats not working either,
I have set joins on all of them.

Appreciate any help.

.

Relevant Pages

  • Re: Contacts Tables
    ... Im designing a database for people responsible for applications at my work. ... I have set joins on all of them. ...
    (microsoft.public.access.tablesdbdesign)
  • Re: polymorphism (was: Poly Couples)
    ... but this is not really "business software"... ... Most of such applications are built as a combination of ... database with flat files or a different RDBMS vendor?" ... couldn't care less if I do it in using structured programming or OOP ...
    (comp.object)
  • Re: Unisys OS/2200 DMS / TIP / COBOL Migration
    ... support the legacy system api's that the application is using. ... differences in COBOL compiler dialects. ... What DBI does is to provide legacy database (DMS) ... the legacy database to the COBOL applications. ...
    (comp.sys.unisys)
  • Re: Database set up help
    ... let's see...I choose the y/n data type because I am using ... User opens up form and enters Employee Information in the fields ... 2 of the 38 options in my main menu are BPCS Applications ... I set up a database with this so far: ...
    (microsoft.public.access.gettingstarted)
  • Re: Advice needed for a growing Access 2000 project
    ... However, it turned out that quite a few of those were "leftovers" from previous releases, no longer accessible from anywhere but the database window, and, thus, no longer used. ... But that certainly isn't the _norm_ -- without any 'heroic' measures, there are routine reports of split Access DBs ... Finally, in my opinion, for "Windows apps", that is, individual-user applications, modest-sized multiuser applications, and client-server applications of any size, Dot Net does NOT "help along" any of these issues. ... The post I reference was in reference its self to the MS Access Help file under "Microsoft Access database general specifications" ...
    (comp.databases.ms-access)