Hi I have a table which stores measurements, the measurements have a corresponding letter assoiciated with them i.e A = 0.34 B = 0.35 etc.
Measurements are directly related to the productPart table. The productPart table stores part no info relating to the product and measurements. One product main contain 1 or multiple part no's i.e Product: UFC-SLOTTED Part No: 21U, 22U, 23U, 24U Each part number has it's own set of measurments i.e Part No: 21U Measurements: A=0.23, B=0.34, C=0.23 Part No: 22U Measurements: A=0.23, B=0.34, C=0.23, D=0.45, E=0.46 As you can see the part numbers can use a varying amount of measurments, which is where my question comes. Part No: 21U has 3 measurments; A,B,C Part No: 22U has 5 measuremnts; A,B,C,D,E I need to fill the gaps automatically to produce the following and place NA or a null value. Part No: 21U Measurements: A=0.23, B=0.34, C=0.23, D=NA, E=NA, Part No: 22U Measurements: A=0.23, B=0.34, C=0.23, D=0.45, E=0.46 Once the user has completed inserting the measurements for the part no, i will offer a button to finalise product insert. I know i will need to loop around the the measurement table for each part no, but how do i know when to insert the correct title(i.e D) and the null value, what if statment will i use, i'm sure it must be possible. Table structure below; productPart productPartID(uid), partNo, lamNo measurement mID(uid),mPartID(link to productPart), mTitle, measOne Thanks Jason ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:328263 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
