I’ve decided to try and set up a form which will list details about individual customers and then at the bottom will include a sub-form listing any activities for the customer.
I have two tables: customer profiles which lists the information about the customer and activities which will be used as an inputting table to save details of the activities.
In my activity input form I was wondering if there is an easy way of automatically filtering fields.
So for example if I am adding in a new event in the east midlands I would select this from my list (created using the lookup wizard) and then in the next field which is region it would automatically only have the regions for the east midlands, and then the next field would be customer name and this would only list the customers in the region I’ve selected. Does that make sense?
Effectively what I’m trying to do is limit the number of customers which inputters can select from to reduce input error.
If anyone could point me in the right direction of some easy guidance that would be much appreciated.
I have two tables: customer profiles which lists the information about the customer and activities which will be used as an inputting table to save details of the activities.
In my activity input form I was wondering if there is an easy way of automatically filtering fields.
So for example if I am adding in a new event in the east midlands I would select this from my list (created using the lookup wizard) and then in the next field which is region it would automatically only have the regions for the east midlands, and then the next field would be customer name and this would only list the customers in the region I’ve selected. Does that make sense?
Effectively what I’m trying to do is limit the number of customers which inputters can select from to reduce input error.
If anyone could point me in the right direction of some easy guidance that would be much appreciated.