portals and value lists

[legba42]

Is there any way to use a value list to populate a row in a portal?

Consider this scenario of a simple sales tracking database ....

Database A contains a list called item numbers.

Database B contains a layout with a portal of Table C, call this layout order entry

Database C contains a list of individual orders.

In db B I have a layout displaying all of a customers orders, using a portal to display those rows. I would like to have a value list (menu style) of all the item numbers and use that value list to help automate adding an order to db C. It would be great if the value list could be contained in the portal itself, simply just be one of the fields. Once I choose a value from the list the rest of the portal row will fill in with lookups.

If the value list needs to be outside the portal then can you suggest a script/process by which once that value is choosen a record be added to db C?

I have all the individual pieces working except how to combine using the value list to choose an item and then add that new record to the orders.

Thanks,

Brian