Copy Records from one table to another

[chrisknight55]

EDIT: Found it.

I want to move Students records to my Graduates table. Is there an APPEND function similar to what dBase has/had?

[bcooney]

Students and Graduates, imho, should be in the same table. The difference is a flag field.

[chrisknight55]

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.

[bcooney]

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

[comment]

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?

[bcooney]

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.