display data

[Dale]

Help. I am setting up an inventory data base. On my
forms how do I get information from more than one
field(s) to display without combining several fields into
one. Right now my fields are CUSTOMER NUMBER, MFG, MFG
NUMBER, MFG DESCRIPTION. One 'CUSTOMER NUMBER' may have
multiple MFG's each with unique numbers. I would like to
be able to select a customer number with the unique MFG,
MFG NUMBER, MFG DESCRIPTION that can be displayed on the
Purchase Order form. Can this be accomplished?

 

[John Vinson]

Help. I am setting up an inventory data base. On my
forms how do I get information from more than one
field(s) to display without combining several fields into
one. Right now my fields are CUSTOMER NUMBER, MFG, MFG
NUMBER, MFG DESCRIPTION. One 'CUSTOMER NUMBER' may have
multiple MFG's each with unique numbers. I would like to
be able to select a customer number with the unique MFG,
MFG NUMBER, MFG DESCRIPTION that can be displayed on the
Purchase Order form. Can this be accomplished?

I don't understand two things:

1. A Form can display hundreds of textboxes based on different fields
(or even on the same field). Whay would you need to combine several
fields into one to see them?

2. Your request appears to contain a contradiction; you say "One
'CUSTOMER NUMBER' may have multiple MFG's" and also that you want to
"select a customer number with the unique MFG". Is it unique, or not?
If it's not unique, what do you want to display?