Would you be so kind to help?
I have a table Firms,with fields:Code,FirmName,FirmField
I have a table WorkingForm that has the Field
roject;Firm;Manager
I made a form to add firms from Table Firms to table Working form: I make a Subform where there are the list of FielmFields and a button Add. When the use press this button,all the firms of that field are added to the table.
Now I`ve done that with macros. But in it I cant check witherer there is a same field in the table.I know that it could be done with VB.Could you advice me how?
The reason is that I would to aviod that one 2 managers add one firm on the same project.
So the code should:
Find in the table Firms the firm that has the selected FirmField
Check whther in WorkingForm there is no line with that Firm on the project selected
If no than add a new line to WorkingForm
Find the next one . . .and so on
Thanks a lot for help
Arseniy
I have a table Firms,with fields:Code,FirmName,FirmField
I have a table WorkingForm that has the Field
roject;Firm;ManagerI made a form to add firms from Table Firms to table Working form: I make a Subform where there are the list of FielmFields and a button Add. When the use press this button,all the firms of that field are added to the table.
Now I`ve done that with macros. But in it I cant check witherer there is a same field in the table.I know that it could be done with VB.Could you advice me how?
The reason is that I would to aviod that one 2 managers add one firm on the same project.
So the code should:
Find in the table Firms the firm that has the selected FirmField
Check whther in WorkingForm there is no line with that Firm on the project selected
If no than add a new line to WorkingForm
Find the next one . . .and so on
Thanks a lot for help
Arseniy
