Jump to content
View in the app

A better way to browse. Learn more.

FMForums.com

A full-screen app on your home screen with push notifications, badges and more.

To install this app on iOS and iPadOS
  1. Tap the Share icon in Safari
  2. Scroll the menu and tap Add to Home Screen.
  3. Tap Add in the top-right corner.
To install this app on Android
  1. Tap the 3-dot menu (⋮) in the top-right corner of the browser.
  2. Tap Add to Home screen or Install app.
  3. Confirm by tapping Install.

Featured Replies

EDIT: Found it.

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

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

  • 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.

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

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?

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

Important Information

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

Configure browser push notifications

Chrome (Android)
  1. Tap the lock icon next to the address bar.
  2. Tap Permissions → Notifications.
  3. Adjust your preference.
Chrome (Desktop)
  1. Click the padlock icon in the address bar.
  2. Select Site settings.
  3. Find Notifications and adjust your preference.