| Item Input Table | Entry Table | |||||||||||||
| SR # | Name | Type | Size | Price | Date: | Item Name | Type | Size | Price | |||||
| 1 | Fuels | Diesel | N/A | 109 | 01-Dec | OIL | ? | ? | ||||||
| 2 | Fuels | Petrol | N/A | 100 | ||||||||||
| 3 | Bearings | Ball | 6206 | 65 | ||||||||||
| 4 | Disc | Cutting Disc | 4" | 200 | ||||||||||
| 5 | OIL | Mobil Oil | Barrel | 3600 | ||||||||||
| 6 | OIL | Hydraulic Oil | Cane | 490 | ||||||||||
| 7 | OIL | Break Oil | Cane | 490 | ||||||||||
| 8 | ||||||||||||||
| I set a drop down list in entry table's item name column it shows the names from Item input table's name column. But I have same Item | ||||||||||||||
| names with different types. Here I want to set another drop down list in entry table's type column who show only those item types that I select in item names. (e.g I select Oil and next column drop down list show "Mobil Oil" "Hydraulic Oil" and Break oil) |
<tbody style="border-collapse: collapse; border-spacing: 0px 0px; font-size: 13px; margin-bottom: 0px;">
</tbody>
