Hello,





in advance, many thanks!





I would like to combine all properties like this:





Property1 Property2 Property3
Property4..


IP54 Yellow With lamp 30W


IP20 Blue Without lamp 40W


Red
50W



60W





In the first step I would like get this:


IP54-Yellow-With lamp-30W


IP54-Yellow-With lamp-40W


…


IP54-Yellow-Without lamp-30W.





(in the next step, I would like to set Properties which are not possible,
for example 60W is not possible if the Color is red)





For this, I have two tables:





Table A


ID Property (color could be value 1, lamp, IPXX, Watt..) integer


POS (in this sequence I would like to generatet he result) integer


ID itself, Integer, self generated.





Table B


ID itself auto generated integer


ID_Table A references to Table A


Property – (yellow, red..)





For example,


Table A


ID Property POS ID itself


1 (Color) 1 10


2(lamp) 2 11


3(Watt) 3 12








Table B


ID itself ID_Table_A Property


101 10 RED


102 10 BLUE


103 10 White


104 11 With Lamp


105 11 Without Lamp


105 12 30 Watt


105 12 40 Watt


105 12 50 Watt





Now I would get:





Red-With Lamp-30 Watt


Red-With Lamp-40 Watt


Red-With Lamp-50 Watt


Red-Without Lamp-30 Watt


Red-Without Lamp-40 Watt


Red-Without Lamp-50 Watt


Blue-With Lamp-30 Watt.. and so on





How can I realize with firebird?





Thank you.





Best regards





Olaf











Mit freundlichen Grüßen / with best regards





Olaf Kluge












S A T R O N Sachsen


Steuerungstechnik GmbH


Johann-Gottlob-Pfaff Straße 7


D-09405 Zschopau








Tel: +49 (0) 3725 / 3506-31


Fax: +49 (0) 3725 / 3506-12


Mobil: +49 (0) 170 / 9292375


E-Mail: <mailto:olaf.kluge@...> olaf.kluge@...


Internet: <http://www.satron.de/> http://www.satron.de/





............................................................................
................


Geschäftsführer: Bernd Grötzschel, Gerd Kaden


Amtsgericht: Chemnitz HRB1218


Ust-ID-Nr: DE141294791





............................................................................
................


Diese E-Mail ist vertraulich. Wenn Sie nicht der beabsichtigte Empfänger
sind, dürfen Sie die Informationen nicht offen legen oder benutzen. Wenn Sie
diese E-Mail durch einen Fehler bekommen haben, teilen Sie uns dies bitte
mit, indem Sie die E-Mail an den Absender zurücksenden. Bitte löschen Sie
danach diese E-Mail.


This email is confidential. If you are not the intended recipient, you must
not disclose or use the information contained in it.


If you have received this mail in error, please tell us immediately by
return email and delete the document.












[Non-text portions of this message have been removed]