Do I need a third table in my schema
===

Scenario: Each **"order"** can only have one **"import file"** . So I created a table with its main columns as *order_code* and *file_code*  (Order_File Table)
Also Each **"order"** can have multiple **"Genes"** . So I created another table with its main columns as **order_code** and **gene_code**. ( Order_Gene table)

So now in front-end side, user picks an "order" from a combobox,  We show the import file of that order and the lists of genes for that order.

I wanted to know your opinion about this schema design and if I am designing it wrong or it is correct?  Thanks. 