|
|
Our Hot Pick: Rising Antivirus 2006 - Certified by TUV & Checkmark! Get 10% discount by entering this coupon code: ONDISCOUNT10
I got table with mobile phones called 'tMOBILE' with the fields:
IMEI - imei number - primary key (text - unique index)
Name - name of mobile (text)
Colour - the colour of the phone (text)
Only IMEI field is unique, name and colour could repeat, because this table
reflects the state of stock.
How to open a new page with recordset set like result of following query?
SELECT DISTINCT tMobile.Name, tMobile.Colour
FROM tMagazynTel_G
WHERE (((tMobile.Name)="SiemensC65"));
Notice, that "SiemensC65" is just example, in DAP code I'd like to use a
variable (called 'pName', wich is set up by code that I already have working
fine (thanks to PaulD).
So to recap, I'd like to open a new page with fields with 1 given name of
mobile, and the quanity of records is idicated by number of DIFFERENT colours
(remember that colours could repeat). To put it in another words I'd like to
get only the first cobination of given model, and each different colour
(omiting the colours that we already had before) as a recordset of the new
DAP.
Please place complete source of event onclick for button let's call it
'ChoseColour', this source should open a new page let's call it 'results.htm'
with the filtered recordset.
Ps. If someone knows another method that server filters, then don't hesitate.
|
|
|