Question

I have two tables in microsoft access with a common primary key as registration number. How to display different records from both fields at same time? 1

Answer 1

$\boxed{\bf{\blue{\bigstar Answer:}}}$

Tab + Alt

Answer 2

If a primary key value has meaning, it can change which requires updating the tables that reference this value. That may be automatic through cascading referential integrity, but it adds overhead, slows performance, and may create locking conflicts as the data is updated