what I have done:
I created a product table in base, with name and price among the other fields
I created a "bill" layout in calc, which will print on a pre-printed sheet
is it possible to have a drop-down list in one of the cells, from which to select an item, and consequently have its price display, and print in another cell?
If yes, please explain how.