I’m building a database for brokering products. I have a lot of offers and requests. I built a form where I can look up offers (in one table) or requests (in another table). Users are supposed to select an offer OR a request from a drop-down menu (lookup) in the form. However, when I look at the form in the edit mode, it shows all the information for each entry in either the offer or request table.
When I activate the form, however, all I see is the name/number of the offer/request, but none of the additional information. I also can’t search by any other fields.
This should be rather basic, but - I just can’t fix it.