I have an HR Database, contained within it is a form to enter supplier contact details (i.e. recruitment firms) [frmrectoreccontacts]. The name of the field that holds the supplier company name is [Company].
Due to the set up of the database it is fairly clunky and basic but there is a link in an employees record to show who supplied them. This links to a sub form that, on the supplier page, shows who they have introduced to us.
When I am entering a new employee there is a drop down box showing a list of recruitment firms for me to select who supplied them from a control source [tblWhoIntroduced]. If the supplier isnt listed in the drop down then I need to go to the [frmrectoreccontacts] to enter a new supplier. The trouble is that the new supplier isnt linked to the drop down box in the employees record as this is formed from a separate table [tblWhoIntroduced].
I would like to produce a command button which sits in the supplier record [frmrectoreccontacts] and copies the supplier company name [Company] and adds that to the table that forms the drop down box [tblWhoIntroduced]. It would then refresh the dropdown box in the employees record [frmResearchAllDetailsMainPage]
Can anyone help - is this possible?