A
AAA
Hello!
First:
Is there a way in which I can trick the FP database
interface wizard to do the database editor using not all
the records in the table but those meeting a certain
criteria? I mean in the list.asp page generated by the
wizard I would like to use a query similar to: "Select *
from table where table.field = ::datareceived::" instead
of "select * from table"
The problem is that I have a "detail table" that holds
several records related to only one record stored in
a "master table" and I'd like to be able to edit the
detail records for only one master record.
The secod question is :
I have a table with a currency field and I need to show
not only the value of that field for every record but the
sum of the values of all the records' currency fields.
For example: In a table called ITEM I would like to list
the price for each item (ITEM.PRICE) and the sum of all
the prices of the items in table.
First:
Is there a way in which I can trick the FP database
interface wizard to do the database editor using not all
the records in the table but those meeting a certain
criteria? I mean in the list.asp page generated by the
wizard I would like to use a query similar to: "Select *
from table where table.field = ::datareceived::" instead
of "select * from table"
The problem is that I have a "detail table" that holds
several records related to only one record stored in
a "master table" and I'd like to be able to edit the
detail records for only one master record.
The secod question is :
I have a table with a currency field and I need to show
not only the value of that field for every record but the
sum of the values of all the records' currency fields.
For example: In a table called ITEM I would like to list
the price for each item (ITEM.PRICE) and the sum of all
the prices of the items in table.