Edit Form based on 1 table & 1 Query. The Query is based on 2 tables

Base 7.3.7.2. The tutorials say that you can’t edit a query from two tables. I can’t edit my tables either because the Master Vendor does not tell me what seeds they sell, and the Master Seed does not tell me what vendor it comes from. I have to use a third table to join them. I have a simple boolean field for organic seed that needs a check for yes, or no. I can’t get to it from either form, and I can’t search for answer online without going down a rabbit hole. Please tell me; do I need to write SQL code for this or is there another way to do it?

Really? The query needs the primary keys of all tables, which are included in the query. If there isn’t set an alias to one of the tables you could change data in such a query, delete data …
Had a look at your query and couldn’t find such a construction in the relationships you posted before.

Thank you. I listed all the primary keys but I tried to make them invisible. I re-added them and all is working now. Much appreciated. :smiling_face_with_three_hearts:

I am making progress thanks to all the help posted here. Thank you everyone