Hello,
I'm trying to build a simple CRM database. I have attached it to this message.
I created a form to enable the user to enter company information. The name is frm_company. Within the form, there is a listbox which allows the user to select one or more tags for the company (lst_tag). There is another listbox, to enter one or more sector information for the company (lst_sector).
The first problem I ran into is that the form does not display information from the connected tables.
The second problem is lst_tag. When I try to select a value, it displays "cannot add record(s); join key of table 'tbl_companytag' not in recordset" error. Checking the form's Record Source, I see tbl_companytag in the records.
I'm more than confused
Anybody can give me a hand?
Thank you,
Tolga