Well i managed it on my own ( only today i succeeded) with this sql.
I even had to add some more joins
thank you for the reply
SELECT main.Idnumber, `Referentie`,
`Omschrijving1`As Omschrijving, `Prijs`, `Pk`, `Type`, `Bouwjaar`, `Uren`, `Banden_voor`, `Banden_achter`,
ja_neen1.ja_neen1 As...
if you take care of your ID's yourself, you just could move the the Id's up by adding the number of rows that you want to insert to the Id:
UPDATE set newId=ID+NumberOfrowsToInsert
Of course if it is a linked table it would give you problems as you would have to update it also to the sub-tables...
Hello there.
I have a form with 5 yes/no dropdown fields.
I want to display col1 (yes/no in dutch)
or col2(yes/no in french) col3(yes/no in english)
my main table has as fields Airco, hydraulics etc...
The yes_no has to come from a table as depending on the language choosen i gets col1,col2 or...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.