Major Form Design

[Nanette]

Really need some help on this. I'm in over my head ))

From a form/query I need the user to input an RFQ #. This should give him a
listing of RFQ #'s that match. Now the person should see another screen (or
same screen with different options) that lists the selected RFQ #'s with
another option box to choose from the multiple Change #'s that belong to the
specified RFQ. After selecting the Change #, a new screen is seen that
contains all the RFQ #'s with the matching Change #'s. Now another option
appears so that the person can choose from a list of Line Item #'s. After
the Line Item #'s are chosen, I need to populate a form with these three
fields and populate several other fields. The data for populating the form
comes from the LineItem table, a BOE table, and a Pricing matrix table.

Within the process above, I also need the system to check the RFQType field
to determine if the return data rows have an "R" or "C". (The data will
always be either an "R" or "C".) This RFQType (R or C) refers to a pricing
matrix. If the RFQ Type is R, certain fields of the predefined form need to
be populated with specific numbers. Of course, if the RFQ Type is C, the same
fields of the predefined form need to be populated with other specific
numbers.

Tables are:
Table: RFQ, Field: RFQNo (Many choices) PK
Table: RFQ, Field: RFQType (Choices are R or C)

Table: LineItem, Field: ChangeNo (Many Choices), Maybe a 3 PK primary key?
Table: LineItem, Field: RFQNo (Many Choices), Maybe a 3 PK primary key?
Table: LineItem, Field: LineItemNo (Many Choices), Maybe a 3 PK primary key?

Table: BOE, Fields: Many fields (didn't think you needed to know all these)

Table: PriceMatrix, Many fields (didn't think you needed to know all these)

Any help is highly appreciated!!

 

[John Nurick]

Hi Nanette,

This is too big a question to answer in a newsgroup post. But if you go
to http://www.mvps.org/access/_vti_bin/shtml.exe/search.htm and search
for
listbox
you'll find some useful stuff. Also it's worth doing a newsgroup search
(e.g. at Google Groups) for something like
"cascading comboboxes" group:microsoft.public.access.*

 

[Nanette]

Thanks for pointing me in the right direction.

Hi Nanette,

This is too big a question to answer in a newsgroup post. But if you go
to http://www.mvps.org/access/_vti_bin/shtml.exe/search.htm and search
for
listbox
you'll find some useful stuff. Also it's worth doing a newsgroup search
(e.g. at Google Groups) for something like
"cascading comboboxes" group:microsoft.public.access.*

 

[John Nurick]

A pleasure. And feel free to post specific questions here or in the
Forms Programming (formscoding) group.