'No Related record in .....'

[Fizzio]

Can Anyone help, this is doing my head in. I have a main form with 4 tabs. The main form is built on a query from 3 tables PtInfo, RefInfo and DisInfo. PtInfo is the main table with DisInfo and RefInfo linked by an integrity enforced 1:1 link. My problem is when I enter a new record, I can enter RefInfo on 1 tab fine but when enter DisInfo on another tab, it complains that it cannot update the field as I do not have a related record in PtInfo (which I have just entered!). I have checked my relationships, table sturcture to no avail. Am I missing something obvious or will I have to revert to subforms?
PS is it better practice to use subforms on tabs or fields from a multi-table query?

 

[Leo J]

I had that once, I used an Access Project with the Jet engine. There was no reason for this since the SQL server allowed the add and edits. I ended up combining the tables.
But if you are using either Access tables or SQL tables on a server. I would open the query and see if I can add from there. The other thing you can do is after you add the first record, minimize the form and see if the tables have been updated. Go look to see that those new records were actually added to the tables. If they are not there, then you need to force Access to update the records before you go on with populating the record in the second table.

 

[Fizzio]

Thanks, I didn't think to try adding the data via the query directly as a test.