Search the Community
Showing results for tags 'self-join table'.
Using a self-joining table to enter part numbers and quantity required to view description, pricing, discount structure etc. When entering a part number that doesn't correspond with any part number on the stock list (part number and quantity table self-joining to stock list) it will obviously not show any other detail as there is no data to match, but I would like to set a default value for the description field when no match is found to display 'Invalid Part Number'. I've had some ideas on how to get it done but keep getting stuck as I also want to display this in the Table View wit