Combo hold data

[Emma Bielawski]

Hi All,

I wonder if someone can help?

Situation
I have a contact form with the date which defaults to now()
the contact type which is a combo box
the employee = a combo box
the company contact = a text box
notes = text box.

Problem:
I want this data input to be as efficient as possible, I would like the
company contact to be a combo box that filters only the contact for the
company that you are in and to hold the data or simply keep the display for
future reference. This info is on a continuous form.

Thanks

Emma

 

[Emilia Maxim]

Hi Emma,

Situation
I have a contact form with the date which defaults to now()
the contact type which is a combo box
the employee = a combo box
the company contact = a text box
notes = text box.

Problem:
I want this data input to be as efficient as possible, I would like the
company contact to be a combo box that filters only the contact for the
company that you are in and to hold the data or simply keep the display for
future reference. This info is on a continuous form.

Question:
What do you mean by "only the contact for the company that you are
in"? Is it the employee you mean?
And do you have somewhere a table with all the companies? If so,
what's the relation between companies table and contacts table?

Best regards
Emilia

Emilia Maxim
PC-SoftwareService, Stuttgart
http://www.maxim-software-service.de