Hi
I have a table for enquiries from customers and I populate this through a form.I have a field ( combo getting its values from Categories table) for category of product under enquiry. I have a separate suppliers table with a field for category to query it to get list of suppliers under the relevant selected category criteria.
What I need is as follows. Based on the data input in the category field in the customer enquiry form, I need a command button clicking which will produce the relevant list of back suppliers in a list box or similar, visible in the form or separately where I can then make a selection of the suppliers from that shortlist to send out requests for quotes by a mailmerge operation. Is this possible or could someone please advise an alternate way to achieve the result.
Please help.
nvk
I have a table for enquiries from customers and I populate this through a form.I have a field ( combo getting its values from Categories table) for category of product under enquiry. I have a separate suppliers table with a field for category to query it to get list of suppliers under the relevant selected category criteria.
What I need is as follows. Based on the data input in the category field in the customer enquiry form, I need a command button clicking which will produce the relevant list of back suppliers in a list box or similar, visible in the form or separately where I can then make a selection of the suppliers from that shortlist to send out requests for quotes by a mailmerge operation. Is this possible or could someone please advise an alternate way to achieve the result.
Please help.
nvk