Cascading Lists On A Form?

Hello all,

I’m building a database for my studies and have hit a major snag with the final form build/design. The db is for a mug ordering system. The mugs are defined by…

The supplier – The Category – The Type – The Style
(whereby The Style is the final name for a mug).

The relationships have been designed as per the first attachment.
(see first screengrab)

Before I go on, do these relationships look realistic?

What I want for the final form to provide is 3 option boxes on the left, which would have to be setup as cascading fields. So when a Category name was chosen, it would then list the relevant Types in the next option box, and when the Type was chosen, the relevant Styles would be listed in the Style box. When the customer had chosen the final mug style, I would then assign a macro to copy the details to an adjacent form which would include customer details and final purchase cost.
(See attached second screengrab)

Can anyone please shed some light on this, particularly the cascading field’s option, as I am at my wits end trying to solve this?

I have looked at the help file “Cascadinglistsdemo” to no avail.

Cheers

SR