let's say we have 5 tables:
1) Observation
2) Location
3) Species
4) Quadrat
5) QuadratSpecies
Observation is our main table/list with joins to the other tables as :
Observation LEFT JOIN Location ON Observation.Loc_ID=Location.Loc_ID
Observation LEFT JOIN QuadratSpecies ON Observation.QuadratSpecies_ID=QuadratSpecies.QuadratSpecies_ID
QuadratSpecies LEFT JOIN Quadrat ON QuadratSpecies.Quadrat_ID=Quadrat.Quadrat_ID
QuadratSpecies LEFT JOIN Species ON QuadratSpecies.Species_ID=Species.Species_ID
all these joins are made from Observation List (is that right?)
Continue:
as you can see i have Observation as main table with many joins.
The Observation has Location_ID foreign key references Location.Location_ID
and QuadratSpecies_ID FOreign key references QuadratSpecies.QuadratSpecies_ID
the QuadratSpecies has also Quadrat_ID as foreign key references Quadrat.Quadrat_ID
and Species_ID as FOREIGN KEY references Species.Species_ID
Now. I have the Observation Form with the following groups made:
Observation (the main)
Observation-[Location]
Observation-[QuadratSpecies]
Observation-[Quadrat]
Observation-[Species]
when i go to Form as you can check: http://archipelagosdatabase.com/index.php/form-demo
( i can provide you with pass and username)
there is The QuadratSpecies_ID wich i want to take value or Values (As the QuadratSpecies_ID is repeatable) after the form QuadratSpecies is submited and has store the new QuadratSpecies_ID's in the database.
Is any way to take automatically the new created values? it's maybe only one but it could be 3,5 ,10 i don't know how...
am i doing anything wrong?
please give me any help cause i'm stuck here.... thanx
1) Observation
2) Location
3) Species
4) Quadrat
5) QuadratSpecies
Observation is our main table/list with joins to the other tables as :
Observation LEFT JOIN Location ON Observation.Loc_ID=Location.Loc_ID
Observation LEFT JOIN QuadratSpecies ON Observation.QuadratSpecies_ID=QuadratSpecies.QuadratSpecies_ID
QuadratSpecies LEFT JOIN Quadrat ON QuadratSpecies.Quadrat_ID=Quadrat.Quadrat_ID
QuadratSpecies LEFT JOIN Species ON QuadratSpecies.Species_ID=Species.Species_ID
all these joins are made from Observation List (is that right?)
Continue:
as you can see i have Observation as main table with many joins.
The Observation has Location_ID foreign key references Location.Location_ID
and QuadratSpecies_ID FOreign key references QuadratSpecies.QuadratSpecies_ID
the QuadratSpecies has also Quadrat_ID as foreign key references Quadrat.Quadrat_ID
and Species_ID as FOREIGN KEY references Species.Species_ID
Now. I have the Observation Form with the following groups made:
Observation (the main)
Observation-[Location]
Observation-[QuadratSpecies]
Observation-[Quadrat]
Observation-[Species]
when i go to Form as you can check: http://archipelagosdatabase.com/index.php/form-demo
( i can provide you with pass and username)
there is The QuadratSpecies_ID wich i want to take value or Values (As the QuadratSpecies_ID is repeatable) after the form QuadratSpecies is submited and has store the new QuadratSpecies_ID's in the database.
Is any way to take automatically the new created values? it's maybe only one but it could be 3,5 ,10 i don't know how...
am i doing anything wrong?
please give me any help cause i'm stuck here.... thanx