[pilot-db-list] Fine tuning an order DB using Pilot-DB

[dual <du...@rd...>]

First of all: sorry if this message reaches you many times since I've =
tried more than once to send it and it is the first time I send a =
message.

Hello,

My name is Daniel Cristut and it it only one week since I'm trying to =
build an order DB onto a Palm.

I've hence discovered Pilot-DB and I must say it is a GREAT tool. I've =
actually managed to build my own database in less than 15 minutes.

Right now my order database looks like this:
    Product_code        string
    Product_price1       float
    Product_price2        float
    Customer1_qty1    integer
    Customer1_qty2    integer
    Customer2_qty1    integer
    Customer2_qty2    integer
    ....
    CustomerN_qty1    integer
    CustomerN_qty2    integer

It's more like a spreadsheet and each customer has 2 columsn:1 - normal =
order; 2 - promotions (related to the two prices of the product)
I've also built a view for each customer, containig: Product_code, =
CustomerI_qty1, CustomerI_qty2, Product_price1 and Product_price2
therefore is very easy to collect data for a particular customer: you =
only select the appropiat view for him and collect the quantities for =
each product.

All above information is generated into an info file I use when I =
convert the CSV database into a PDB (CSV2PDB)

And here's my question (at last ) : How can I, in the INFO file I use, =
specify the parameter "Use this view to edit a record", very important,
since I want to edit only those columns associated with the current =
customer's view (actually each customer has his own view).

And one more question: Where and how can I insert a script to calculate =
the value for the current view=3Dcustomer, i.e.=20

(+  (* Product_price1 CustomerI_qty1) (* Product_price2 CustomerI_qty2)) =
for ALL the records in the database

(I think I need some function -or some trick- to associate the field =
number with the current view, because Product prices field numbers are =
constant
but CustomerI_qty1 / 2 are variable depending to the current =
view/customer )

Thank you very much
Daniel