Direction Question

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need to create something where a user can choose a RFQNumber, it's
ChangeNumber and it's LineItemNumber. And also I need the option to choose
all of the RFQNumber, its ChangeNumbers, and its LineItems. Once I have this
data, I'll need to auto select(?) other fields that match these three choices.

I've learned how to use Cascading Combo Boxes, but I'm not sure I'm going in
the right direction.

I will need to take the chosen data (RFQNumber, ChangeNumber(s), and
LineItemNumber(s) and its corresponding data and put that data into a report
format for printing as well as export it into an Excel document. There will
also be a query involved to pull data from a pricing table along with the RFQ
data.

I was planning to have the data appear in a form first for final tweaking by
the user.
Then somehow pull all the data (query?) from the form into a report as well
as an Excel document.

Any suggestions on if I'm going in the right direction would be greatly
appreciated.

Or suggestions on a better direction.
 
Hello again Nanette,

You seem to be everywhere! :-)

Everything you describe is feasible; yes, you're going in the right
direction. However take it one step at a time; trust me when I say that data
can be presented to the user for 'final tweaking', that related data (pricing
info.) can be retrieved from other tables, and that data can be automatically
loaded into Excel; first concentrate on the cascading combo boxes.

It's probably best to use the AfterUpdate event of the combo boxes to
synchronise everything. Allow for the fact that users are unruly and will
display a tendancy not to select from the combo boxes in the logical order of
RFQ, Line, Change. Thus you need to disable the 'downstream' combo boxes
until a valid choice has been made in the upstream box. Your combo boxes will
be unbound. The 'tweakable' data will probably be a bound sub form linked to
the values selected in the combo boxes.

O.K. You briefly mention: 'And also I need the option to choose
all of the RFQNumber ...' Does this mean each combo box list should have an
'All Values' option? What is the logic when this is selected?

Regards,

Rod
 
Hi Rob,

Yeah, I've been everywhere because I'm spending most of my evenings and
weekends trying to learn enough to make this database happen. I'm just very
frustrated at the moment.

What I meant about selecting all the RFQ Numbers was that sometimes the user
might want to choose all items contained within an RFQ Number. There might be
15 items within an RFQ with different ChangeNumbers and different
LineItemNumbers. And, they might also want to select two RFQ Numbers and only
one line item per each RFQ Number. Is this even possible?
 
Back
Top