Help on database.

[aligahk06]

Dear All,



I want to develop a database based on two fields.
INV # and Ack. Status. one search button.

Suppose i want to track Inv # 25104 then i press search button then it display the status.i.e either it is acknowledged
or underprocess.

Which is better either FORM or REPORT or Query .

Please advise if anybody have a sample.


Please Assist?

Rgds,
Aligahk06

[TheShabz]

It all depends on how you want to do it. A form would be good to use if you want to create a User Interface (UI). If you just want to look at it for yourself, you can just use a query. If you want to group many invoices together and view them, it would be a report.

query-wise, its pretty simple
SELECT status
FROM myTable
WHERE Inv# = 25104

As a tip, try to stay away from using spaces and special characters in your field names, it creates headaches.