Hello i have to make a database , have NameRecorder, Date, Transect(every record can have until 3 Transects),Quadrat: 3 Quadrats per 1 Transect. Every Quadrat has species and amount of every species.
example
Location:Vitsilia Transect: 1 Quadrat: 1 Species: 8 Amphiroa rigida, 3 Cladophora, 4 Caulerpa prolifera, 2 Cystosiera crinite.

Location:Vitsilia Transect: 1 Quadrat: 2 Species: 6 codium corraloides, 2 Ulva rigida, 5 Sarcotragus sp,3 Udote petiolata ,7 Rytiphlaea tinctora
and i dont know how to make it this
i make a recodstables which have a key the id and a seconds table transect wich have a key idtra ..
i have confused