March 19, 201114 yr EDIT: Found it. I want to move Students records to my Graduates table. Is there an APPEND function similar to what dBase has/had?
March 19, 201114 yr Students and Graduates, imho, should be in the same table. The difference is a flag field.
March 20, 201114 yr Author Students and Graduates, imho, should be in the same table. The difference is a flag field. Thanks. Umm, I guess I thought the file would grow too large for no good reason or advantage, and thought I would archive them in a separate file rather than a separate table within the same file. But you think they should all be in the same table? I don't know the pros and cons. Thanks for your help.
March 21, 201114 yr One pro is that when Finding, you're searching just one table. Another idea is to use the "Graham" method, and have all People in one table, and satellites for your people types. My link
March 21, 201114 yr Another idea is to use the "Graham" method, and have all People in one table, and satellites for your people types. My link What fields would be in the "satellites" in this case?
March 21, 201114 yr Possibly, he'd have separate tables for Students, Teachers, Graduates....as many types of people as there are, especially if a person can be of more than one type. Or, simply one field in People that indicates type. However, I think reading up on subtype/supertype design is worth it, Michael.
Create an account or sign in to comment