Updateable query??

  • Thread starter Thread starter Orv
  • Start date Start date
O

Orv

I have 4 tables. All have a unique primary key, and one of these tables also
has a second key. This 2nd key is assigned to a field named "RTFnumber".
This same field is also located in the 3 other tables.

OK, I created a form, which was based on a qry of the above tables, and it
shows the data correctly, but I can not edit or add new records.

I beleive this has something to do with a "non-updateable query"?
If this is the case how do I resolve this problem.

Also my tables are related by a 'one to many'

TIA,

Orv
 
How does the 1 to many work?

Table1 - Primary Key - RTFNumber

Table2 - Primary Key - something
- Foreign Key - RTFNumber

Table3 - Primary Key - something
- Foreign Key - RTFNumber

Table4 - Primary Key - something
- Foreign Key - RTFNumber

??
 
No........

Tbl 1 - Primary Key - ID# (Autonumber) (set by Access)
RTFNumber (field)
Tbl 2 - Primary Key -RTFNumber
Tbl 3 - Primary Key -RTFNumber
Tbl 4 - Primary Key -RTFNumber

I need to be able to put a 'non-consecutive number' into the RTFNumber
field, whenever needed.
Also I have tried Tbl's 2-3 with Primary Key = ID as well, with no luck.
 
So the RTFNumber MUST exist in all 3 tables before you can add a record into
T1. Doesn't sound like you data is normalised, ie the data within tables T2,
T3 and T4 do NOT relate wholely to RTFNumber.

Are yuo sure this should not be the other way round, ie T1 has RTFNumber as
PK, and the T2, T3 and T4 have it as FK?
 
Thank you for your help, I got it.
Yes, it was a problem with the relationships.

I appreciate your help,

Orv
 
Back
Top