My Visual Database — how to index one table column with another column?

Re: how to index one table column with another column?

null@example.com (gamingmastar) — Tue, 07 May 2019 06:07:14 +0000

see this too, we only need to type item code and quantity, item name and price automatically popup, and then we click on save invoice no generated, and we easily see our invoice detail by typing our invoice no. hope you understand what i want

Re: how to index one table column with another column?

null@example.com (gamingmastar) — Tue, 07 May 2019 05:56:04 +0000

]It's good, but we only enter one item at a time , I wanna enter multiple items at the same times, I already did this in PHP query, multiple insertion, I need this in pascal. , see php example

Re: how to index one table column with another column?

null@example.com (derek) — Mon, 06 May 2019 20:57:04 +0000

Hi,
Have a look at the attached example and the enclosed screenshot.
I have shown 2 ways of doing what I believe you want.
Option 1 uses a small script to retrieve a product description based on a Part No' that you select from a combobox.
Option 2 does not require any code, you just put the fields you want (Part No' and Description) into the combobox. This also has the advantage that you can then search by entering some of the Part No' or some of the Description, so it is much more flexible.
Derek.

how to index one table column with another column?

null@example.com (gamingmastar) — Mon, 06 May 2019 05:11:28 +0000

i wanna make invoice form which based on tablegrid, first column i put item code in another next column item name automatically popup, its like a excel vlookup function .sorry for my bad engilsh..