Is it possible to use primary key of one table as a primary key in many other tables?if yes, how?
Answer / Tarun Rohiley
In MS Access, the primary key of one table cannot be used as the primary key in multiple tables. However, if two or more tables share common attributes that can uniquely identify records and are defined as the primary key in each table, those attributes are referred to as a Composite Primary Key.
| Is This Answer Correct ? | 0 Yes | 0 No |
Is access a good database?
What is a lookup table in access?
What do you mean by queries?
can we call primary key a 'address'????
How do I get microsoft access 2016?
Is ms access better than excel?
List different query types in microsoft access database
What are the important data types in ms access?
What is the maximum size of a database that can be opened in Microsoft Access?
What is microsoft access?
What are the components of ms access?
Is access faster than excel?
Oracle (3253)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)