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?
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?
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.