Topic: Getting details with SQL
I couldn't get supplier names and address displayed on sale inv item form properly.
One product one supplier seems to be working OK but when multiple products associated to a supplier the it doesn't.
Please see form1 Sale Inv item 2. Try to add Product 0004, 0005 and 0006.
Product and SaleInvItem tables are linked to Supplier table.
Idea is to get supplier details displayed on frmSaleInvItem once a product is selected from cbSIitemProduct combobox.
Please see the attached sample project.
God... please help me become the person my dog thinks I am.