Improve insertion of new entries in tables with foreign keys (make process easier). For example, creating a new Staff entry might require typing in a Person ID (foreign key that links staff record to associated information in Person record), which probably requires looking up the person in the Person table. Several solutions are possible. For example, could provide "drill-down" options from Person record-view to add new Staff (which would receive Person ID when invoked). Or could provide an in-line search mechanism (using AJAX?) or a field lookup similar to auto-completion.
Improve insertion of new entries in tables with foreign keys (make process easier). For example, creating a new Staff entry might require typing in a Person ID (foreign key that links staff record to associated information in Person record), which probably requires looking up the person in the Person table. Several solutions are possible. For example, could provide "drill-down" options from Person record-view to add new Staff (which would receive Person ID when invoked). Or could provide an in-line search mechanism (using AJAX?) or a field lookup similar to auto-completion.