Hi frineds,
I have interesting quest about invoice project.
i have table objects as under:

1) ItemMaster
Fields
  Itemid
  ItemName
2) ItemTransaction
Fields
  ItemIncrmt
  RefItemId
  Rate
  qty

Now my quest starts.....
i want such type of facility in data grid it displays,
  Name of item , rate, qty , total of each item. as well
  Drop down combo at place of Itemname field such that user can update it and i can store refitemid field in database.........???


---------------------------
One more quest ...
in Access How can i retrieve number of raws retrived from query.
like in Oracle .
let me be more specific.
e.g. ItemMaster
      ItemId
      ItemName

select * from itemmaster where itemname like 'a*'
retrives 5 raws then result should be as under

rawno Itemid itemname
1 2 a
2 3 dfd
3 34 ddf
4 12 err
5 1 d d

Plz help me ?