Skip to main content
Solved

How to create & present linked records: course unit -> week 1, week 2, week 3

  • June 23, 2020
  • 2 replies
  • 26 views

Forum|alt.badge.img

Hi,

Looking for the best way to do this. I’ve got a Unit table that stores all the details for a course Unit (e.g. Introduction to French):

I want to specify records for each week of that Unit, e.g. for the Unit “Musicianship 101”, we have a record for Week 1, Week 2, Week 3, etc (tracking information for each week):

Musicianship 101

  • Week 1
  • Week 2
  • Week 3

I created a table Unit Weeks that looks like this:

Where the “Unit” field is a linked record back to the corresponding unit record in *Unit table.

What’s the neatest way to do this?

  • I’d like to hide the “Name” primary field. Is there any way?
  • I’ve used grouping on the “Unit” field and hidden the “Name” primary field. Any better ways of doing this?

Thanks,
Daniel

Best answer by ScottWorld

Nope, you’re doing it correctly.

2 replies

ScottWorld
Forum|alt.badge.img+35
  • Genius
  • 9778 replies
  • Answer
  • June 23, 2020

Nope, you’re doing it correctly.


Forum|alt.badge.img
  • Author
  • New Participant
  • 2 replies
  • June 23, 2020

Nope, you’re doing it correctly.


Ok, thanks mate. Appreciate it.