Combine 2 rows into 1 row
Hi,
I'm not sure if this is possible or not, but I have 2 different columns in a display page- 1 for PNR Initials and 1 for BOM Initials, but when I insert everything into the database, I only have 1 column to handle both the PNR and BOM initials. The way I tell them apart is with another column that is called Document_Type. If it says "PNR Req", then I know to output it into the PNR Initials column. If it says "BOM Req", then I know to outupt it into the BOM Initials column.
Although the inserting works correctly, the display page does not put them next to each other since the data is dynamic and it's outputting each column's initials into their own rows. For instance, I updated the PNR Initial to "VP" and hit the update or insert button and it inserted the PNR Initial into the database. Then I went back to the display page to insert the BOM Initial to "AG". It inserted it correctly. But now when I go back to the display page, there are 2 different rows with the first row that has the drop down menu in the PNR Column and "AG" in the BOM column. But then there is another row that has "VP" in the PNR column and the drop down menu in the BOM column. Since I've updated both columns, it should just show the PNR Initials under the PNR column once and the BOM Initials under the BOM column once, but all in the same row and not on 2 separate rows. How do I get it so they show up on the same row? The 2 different rows are indicated by the APVID 5 and 9, but they both are linked to the same item number 5 in the Items table. Here's what my display page looks like now:
| APVID | APV_ItemID | Part_Number | PNR | BOM |
|---|---|---|---|---|
| 5 | 5 | aaa5 | Drop Down Menu | AG |
| 9 | 5 | aaa5 | VP | Drop Down Menu |
It should look like this:
| APVID | APV_ItemID | Part_Number | PNR | BOM |
|---|---|---|---|---|
| 5 and 9 | 5 | aaa5 | VP | AG |
The APV_ItemID is linked to a column in another table. That table is the ECO_Items table that has the ItemID column that has all the items. The info. above for the APV_ItemID and Part number can always all be the same, but the PNR and BOM columns have to display the correct initals in each on 1 line. I tried the maxrows and the group function on the output query, but those did not work. I've also tried some IF statements, but they do not work either. Any other ideas? Is this even possible?Thanks.
Andy
AdChoices