AnsweredAssumed Answered

Restructuring "People" in an inherited database

Question asked by heatherwilliams on Aug 16, 2017
Latest reply on Aug 21, 2017 by TonyWhite

Let's say I have a table called "People" and in that table is the data for each individual who interacts with our office. Each individual would have a "personnel type" assigned to him/her in this table of either "Student" or "Faculty." What if I then want two layouts exclusively for the different categories of people (i.e., student details, faculty details)? Should I use a script to find the relevant records for each layout based on personnel type, should the data be in two different tables instead of a general people table, or is there another way of setting this up that I haven't thought of yet??