Altering Data in Subform One-to-Many Relationship?

[brcopeland]

I have linked my primary table, A, to another table, B, on A.id=B.id. B may have multiple records associated with a given A.id and so I added a Table Control to display the relevant fields from B. This works fine, but I want to be able to:

1. Change the information in any displayed field in B,
2. Add a record to B,
3. Delete a record from B.

Is there a way to do this from within the table control in the form? Typing text after selecting a field doesn’t do anything and right-clicking only gives the option to copy.

[Ratslinger]

Hello,

It appears either you do not have a primary key set in table B (indicated by not doing anything) and/or you have incorrectly established relationships - one-to-one vs one-to-many.

Can you please post a sample of the Base file with the error (edit question & post there). Please, no personal or confidential information.

[brcopeland]

That indeed appears to have been the issue. I’m using a PostgreSQL database which I cannot share, but this table did not have a primary key defined. After defining one the table control is allowing me to do all of those operations.