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 |
What is form view access?
How many types of databases are there in ms access?
What are the data types in ms access?
Which is better mysql or ms access?
What is the purpose of access?
How do I use excel as a access database?
Does microsoft 365 have access?
What is a database access?
How would you create a report using the report tool and report wizard?
What is the use of pivot table?
What are the limitations of ms access?
What is primary key in ms access 2007?
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)