Jump to content

Related Tables with Template?


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

Recommended Posts

  • Newbies

The title may not be accurate, as I may not have this set up optimally, but here goes:

I have a workout DB that allows me to enter workouts (workouts contain exercises), meals (meals contain foods), and schedule the workouts and meals in a schedule table (links a meal or a workout to a schedule record with a date and time).

An image below illustrates the relationships.


Here's where I'm having trouble:

I want to track my progress as far as weights and reps. This means a seperate "Instance" table for the workout items. When I add a workout to the schedule, the workout items instance portal should populate with the exercises in that workout simply by entering a workout ID. However, I don't see that as possible via my design. I have to create new "instance" records, and copy the workout IDs into them. This is not ideal, and I feel like I'm missing something here (there has to be a better way). I know a but about DB design, relationships, etc, but can obviously use some guidance.

Any help is greatly appreciated.

Link to comment
Share on other sites

This topic is 5776 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

  • Create New...

Important Information

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