Results 1 to 2 of 2
  1. #1
    bancescul is offline Novice
    Windows XP Access 2003
    Join Date
    Jan 2013
    Posts
    1

    Relationships and query help (was I need your help)

    I have to do a database in acces.It”s about a school.c.t.latcu voda siret baza de date.zip


    Can you help me to make the relations into tabel and some complicated query in SQL?

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,771
    You already have tables, queries, forms, reports built. What is specific issue you are having?

    Primary key in clase table is cod_clasa and is an autonumber type. However, clasa field in elevi table is text type and you are not saving cod_clasa as foreign key. Either save the cod_clasa value as the foreign key in elevi table in a number field or change clasa field to primary key in clase table.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Query Help with relationships!
    By lkevinc42036 in forum Queries
    Replies: 2
    Last Post: 08-02-2012, 01:42 PM
  2. Replies: 1
    Last Post: 08-01-2012, 02:17 PM
  3. Query/module to open the relationships tab?
    By olazabal in forum Modules
    Replies: 1
    Last Post: 04-20-2012, 03:11 AM
  4. Query for Many to Many Relationships
    By hlm15 in forum Queries
    Replies: 1
    Last Post: 04-09-2012, 04:52 PM
  5. Query Relationships
    By reidn in forum Queries
    Replies: 2
    Last Post: 06-29-2011, 05:40 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums