HI there,
I have this client master with a whole nuch of information. Most importantly client names, ( last name, first name) etc.. with MasternO as the master key.
I have an activity file with activity no as the master key. it also contains the master no and the 2 master numbers are linked to give activities report etc.
What i wld like is to create a list of all the clients and make a visible list made available for the user to browse through to select reqd. client and then based on the selected client pop up the associated activities for that client like a datasheet. is this possible. eg : if there are 100 clients and the client wants to choose record 27 that belongs to john doe, all of john doe's activities come up beside the list box and the data entry clerk can enter more activities. IF anyone can point me in the direction of how to do this, i wld be very grateful.
I have learned so much from these forums and am amazed at how much one does not know and how much one can learn if only we had the time. Thanks so much for all your input, in advance. Hope my mailo is clear
Thks
usha
I have this client master with a whole nuch of information. Most importantly client names, ( last name, first name) etc.. with MasternO as the master key.
I have an activity file with activity no as the master key. it also contains the master no and the 2 master numbers are linked to give activities report etc.
What i wld like is to create a list of all the clients and make a visible list made available for the user to browse through to select reqd. client and then based on the selected client pop up the associated activities for that client like a datasheet. is this possible. eg : if there are 100 clients and the client wants to choose record 27 that belongs to john doe, all of john doe's activities come up beside the list box and the data entry clerk can enter more activities. IF anyone can point me in the direction of how to do this, i wld be very grateful.
I have learned so much from these forums and am amazed at how much one does not know and how much one can learn if only we had the time. Thanks so much for all your input, in advance. Hope my mailo is clear
Thks
usha