Hello. I’ve never been able to find or perhaps understand a solution to the following problem. I have a MainForm containing many fields from my Company table. It also has a SubForm containing a few fields from my Products table. Each company deals with one or more products.
Entering data on the Mainform and its SubForm is easy and table filters work well to find and edit Company table data and see and edit the company’s related products details in the SubForm.
My question: Is it possible to use this form to search for Product table data?
If one of the companies in the Company table deals with “Apples” I thought I could have the MainForm as described above be based on a Query with a WHERE clause to select company records WHERE products equal “Apples”. I have tried this and it partially works. The data displayed is perfect except it is read-only and cannot be edited which is for me a show-stopper.
Since the products of any one company are usually limited to a few items, I could simply have a text field in the company table, shown on the MainForm, called product_items and enter the products as text separated by commas. LO tables filters will work, and all field and subform data would be editable so this is a solution.
A subform though would offer more options and be more elegant, thus preferred.
Does anyone have an idea on how to implement this or should I just use the simple text field?
In passing I do have other SubForms on my MainForm, such as Contacts and Call History, so everything should be editable for any solution.
My apologizes in advance for posting a similar question previously but perhaps my question is clearer this time!
Thanks in advance for all help.