Skip to main content
Solved

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

  • June 23, 2020
  • 2 replies
  • 44 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.

This topic has been closed for replies.

2 replies

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

Nope, you’re doing it correctly.


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

Nope, you’re doing it correctly.


Ok, thanks mate. Appreciate it.