Hi
I have 3 tables in my database
table 1: id and name (eg 1 April medal, 2 May Medal)
table 2: id and open_date (eg 1 2013-04-01, 2 2013-05-01)
table 3: id and type (eg 1 Mens, 2 Ladies)
my next table holds the id's from the above
first record = 1,1,1
second record = 1,1,2
third record = 2,2,1
fourth record = 2,2,2
in my 4 list which will hold results I want to create a dropdown with a databasejoin and a concat label joining all 3 tables
April Medal, 2013-04-01,Mens
April Medal, 2013-04-01,Ladies
May Medal, 2013-05-01,Mens
May Medal, 2013-05-01,Ladies
etc
Is this possible and if so how.
Thanks
Willie
I have 3 tables in my database
table 1: id and name (eg 1 April medal, 2 May Medal)
table 2: id and open_date (eg 1 2013-04-01, 2 2013-05-01)
table 3: id and type (eg 1 Mens, 2 Ladies)
my next table holds the id's from the above
first record = 1,1,1
second record = 1,1,2
third record = 2,2,1
fourth record = 2,2,2
in my 4 list which will hold results I want to create a dropdown with a databasejoin and a concat label joining all 3 tables
April Medal, 2013-04-01,Mens
April Medal, 2013-04-01,Ladies
May Medal, 2013-05-01,Mens
May Medal, 2013-05-01,Ladies
etc
Is this possible and if so how.
Thanks
Willie