the recordset used to display the course will need to include the orders table and the orders details tables.
the course ID will be stored in the details, also the Order ID will be stored in the details
This will relate to the orders table which stores the User ID which relates to the logged in user.
you need to use a join query to join these tables together, in the where clause, you can add an additional check for the Order.UserID being equal to the logged in user ID.
This is the technique used for the download center.
whether you will be offering downloads or not, the same technique applies.
