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.

Proper tables and relationships

Featured Replies

I need some basic table/relationship help. Although I am not listing all of the fields and tables, I am hoping to get some general theory guidance on proper setup. The solution simply tracks courses that are taught and the costs associated and seems to work fine. Within a teacher layout, I have a dropdown to select the Step, which them populates the salary, and ultimately shows me the cost of the course in a Courses layout. However, what I failed to think about is historical data. As teachers move up the Step ladder and I change the Step in the Step field all data changes for courses they taught to the most recent step salary. I need a way to 'store' all of the Steps of a teacher over time and keep those values with the courses during that time. 

What would be the proper way to construct this? 

 

Tables: Teachers, Courses, PaymentSteps
Teacher fields: ID, Name,....
Courses: ..., ...., CourseCost
PaymentSteps fields: ID, Year, Step, Salary
 

 

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.