Filler suggested parts database

[Fly Boy5]

I want to have 3 tables linked. Filler by serial no., assembly and parts.
It would be nice to track parts to a serial no. or to a model. Some parts
are common between several fillers so if coded properly I could query the
correct suggested spare parts.
It will be important to print the assembly name and number with suggested
parts with quanties below.

Any suggestions would be appreciated. I really struggle setting up links to
provide the information required.

Thanks