Jump to content

Copy Records from one table to another


This topic is 4332 days old. Please don't post here. Open a new topic instead.

Recommended Posts

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.

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

This topic is 4332 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.