Here is my dilema....

I have 3 tables I am working with and one table (tally), I need to only edit records that match certain
search criteria. I have been told the best way to do this by several people is with a view (which I have
never used before). I have tried several attempts at this to no avail, so I am reasking for help....

Here are the tables....

TALLY
tally.eventid
tally.barnum
tally.invdesc
tally.qtystart
tally.qtyend

EVENT
event.eventid (unique)
event.descrip

BAR
bar.number (unique)
bar.descrip


On my form, I have two combo boxes, both drop down lists. The first is cmbEvent where the
operator selects the event to work with via the description. Once they have selected the event,
they move to the next combo, cmdBar. Here they pick the bar to work with via the bar descrip.

Once they have selected both (basically an interactive change method in the cmbBar), I need to
display only the records in TALLY where tally.eventid = event.eventid AND tally.barnum=bar.number.

The operator will then move through the qtystart and qtyend fields for each record in the grid, make
the necessary changes, and those changes need to be recorded in TALLY.






Seeing how I have never worked with views before and personally HATE grids because they hate me..
I am getting more and more lost with this. Can someone, in layman's terms (and hopefully examples)
point me in the right direction with this.

If I need to create a view in the project manager, so be it. If I need to use an CREATE SQL VIEW in
the interactive change method of cmbBar, ok. How and what do I need to do. I also need to know
what I need to do to make sure the TALLY table gets updated with the changes.


Thanks