Apologies for asking a noob question.
I'm trying to create a record (business activity) that I want to link to multiple companies which are in my company table (tblcompany). I looked to add a multi value lookup field in the Activities table (tblActivities) to link the companies but found you cant import multi value field in via excel, did some further research and found lots of people saying to avoid multi value lookup fields.
Trying to work out how I can best do this without a multi -value field.
Each activity in tblActivities needs to be linked to multiple companies that are in the company table.
tblCompany (holds company information)
tblActivities (holds business activities)
I have a form which allows users to select a Company (via combobox) and the aim is to have a subform/subreport then load showing all the business Activities that company has been involved in.
Appreciate any help or advice.
I'm trying to create a record (business activity) that I want to link to multiple companies which are in my company table (tblcompany). I looked to add a multi value lookup field in the Activities table (tblActivities) to link the companies but found you cant import multi value field in via excel, did some further research and found lots of people saying to avoid multi value lookup fields.
Trying to work out how I can best do this without a multi -value field.
Each activity in tblActivities needs to be linked to multiple companies that are in the company table.
tblCompany (holds company information)
tblActivities (holds business activities)
I have a form which allows users to select a Company (via combobox) and the aim is to have a subform/subreport then load showing all the business Activities that company has been involved in.
Appreciate any help or advice.