I have a question that might be simple. I am playing around with an online (hosted) database for a emerging non-profit using PostgreSQL and accessing it right now with phpPgAdmin, a tool provided by the host site. The database is constructed as 3 tables (Organizations, Sales Contacts & Membership Contacts). I have used constraints to require that the Organizations (primary key) matches the linked field in the other two tables (foreign key). Entering new records has been no problem. The problem that I have is (viewing each table in “browse” mode) that only the Organizations table shows up as allowing the records to be edited or deleted (buttons on the far left). Nothing that I have changed has allowed me to edit the linked records in the other two contact tables. Do you have any idea?
Why not run 3 update queries?