您知道主明细表结构吗?
您可以使用Medicine_id制作一张明细表.那张桌子可以像这样:

Hi,

Do you know about Master detail table structure?
You can make one detail table with your Medicine_id. That table can be like this :

TableName : Medicine_Components_Details
1. MCDID(PK)
2. Medicine_id
3. Component_id

因此，您可以在这里获得1种药物的所有成分.
希望这些信息对您有所帮助.

谢谢，
Viprat

So here you can get all Components for 1 Medicine.
I hope this information help you.

Thanks,
Viprat