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
|
