Search results

  1. S

    Query of records that are not part of the join

    Hi, I have a database with one main table (Projects) and 3 other tables (Students, Organizations, Professors) linked to the main one through many-to-many relationships (through linking tables that is). Basically, the organization I work with does research projects, and each project could have...
  2. S

    extended info form problem

    hi, i have a fairly complex DB with lots of demographic info. On one form there is new student information that is continuously added, and there is a buton that leads to extended information for the student. I chose this as a design option since it is simple, and it does not add lots of data to...
  3. S

    replacing ID with something else (not sure what to call this)

    hi, i have two tables, tblContact and tblorganization, linked on a many to one relationship through OrgID (OrgID is foreign key to tblContact). I have created a subform, which is used in another form, to create a link between another table, tblProject and tblContact (these are many-to-many...
  4. S

    Complex relationships

    Ok, let me see if I can explain my situation. I have a database that deals with community-based projects (tblProjects) which are linked in many-to-many relationships with Organizations, Students and Professors. I got the whole architecture of this thing sorted out, but something came up. It...
  5. S

    OpenForm in a subform

    Hello, I searched up and down these forums for about 1 hour or so to find a topic related to my problem, but couldn't find anything... I hope this post is not redudant Anyway, the problem is this one: I have two tables: tblProjects and tblOrgs which are in a many-to-many relationship with...
  6. S

    complicated relationships in a single report

    hello, i'm totally new to this forum, and fairly new to access but i'm gonna send a message just to give it a try.... here is the problem... i have a database with a central table "Projects" and 4 linked tables: Students, Professors, Organisations and Departments. Each of them is in a...
Back
Top Bottom