Re: Help required to populate gridline

--===============2075048401==
Content-Type: multipart/signed; micalg="pgp-sha1"; protocol="application/pgp-signature"; boundary="=-HqkCI1S43vjzKU6JrlKr"


--=-HqkCI1S43vjzKU6JrlKr
Content-Type: text/plain; charset="ISO-8859-15"
Content-Transfer-Encoding: quoted-printable

Hi,

Am Freitag, den 25.02.2011, 17:38 +0530 schrieb Kishan Bhat:
> A user can select a PO number from dropdown choice for which the
> gridline at the bottom will list all sku's for this particular PO
> Number. The user can then choose to enter a number for any of the
> sku's and I'll pick up the non-zero quantities and add them as a new
> row to DB table "invoice_item" and also add them back to the
> "invoiced" column of DB table po_item.

First of all, I think you want the "Make Invoice" tab to list your PO
items, not your (already made) invoice items. So you want to display
data from the "po_item" table, not from the "invoice_item" table, which
only contains invoices you've already created.

For letting the user select a purchase order number from the dropdown
and then show all items of that purchase order, you can do something
very similar to the customer search field you've made: create a field in
an unbound block, link the dropdown to that unbound field, and in the
POST-CHANGE trigger, set the filter for the block displayed in the grid.

A hint on your data design: usually, purchase orders and invoices are
done with (at least) 2 tables: one table e.g. "invoice" containing data
valid for the whole invoice, like customer reference, invoice date,
invoice number, etc, and "invoice_item" containing a record for each
item on the invoice. This is a typical master-detail relationship.

Hope this helps you move forward.

Thanks,
Reinhard

--=-HqkCI1S43vjzKU6JrlKr
Content-Type: application/pgp-signature; name="signature.asc"
Content-Description: Dies ist ein digital signierter Nachrichtenteil

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.10 (GNU/Linux)

iJwEAAECAAYFAk1oCegACgkQKm/Tcod8puOK6gQAiYUPlZb9CBynIB7HC7OMu2vL
HvaEknTEsZNDSnruqLJMKrXq0fQsgVThyrt1L3vN62AsqFBg0CzH4tF+ABbL8OY3
8d48yqdfRq/AJlpdUNVRtvb8l+BrBErpvl1i5crpSfCcPDnPttz1JXhlQbYjyiji
2pFm0V9huPtZIt1UbPk=
=yZCg
-----END PGP SIGNATURE-----

--=-HqkCI1S43vjzKU6JrlKr--



--===============2075048401==
Content-Type: text/plain; charset="us-ascii"
MIME-Version: 1.0
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

_______________________________________________
gnue mailing list
[email protected]
http://lists.gnu.org/mailman/listinfo/gnue

--===============2075048401==--