pick value from list, fill in additional fields

[legba42]

Simple task but I'm not sure how to make it all happen.

First is a table of items, contains fields such as item number, item description, item cost.

Second is a table of orders, an order entry form if you will. On the order entry page I generate a pop-up menu value list of the item numbers from the first table. The idea here is to click on the popup menu, pick an item by number, then fill in a few other fields to complete the entry for this order.

My question is this ... how do I fill in the other fields on the order page? The pop-up list just fills in the one field, how do I pull the rest of the item data over to the order page based on choosing the item number?

Thanks .... !!

Brian

[legba42]

So I hacked yesterday and figured out how to use lookups. That is exactly what I need. The next question is this ... is it possible to use a portal in which the fields of the portal can autofill using the lookup functionality?

I have 3 tables, one is items, one is customers, one is orders.

The customers layout needs to contain a portal that lists all of the customers orders. To add an order I wanted to use the lookup to then pull specific items.

Thanks ....

Brian