"You cannot add or change a record": HELP please

S

scubadiver

I have the following relationships:

tble_query -> 1:n -> tble_Ccode <- n:1 <- lkup_CcodeS <- n:1 <- lkup_CCodeT

I have a form which holds "query" information and I have a subform which
holds "CCode" information. The subform consists of a cascading combo that
sources "lkup_CCodeT" and "lkupCCodeT".

The two look-up tables have all the information I need. In the subform, if I
choose from the list in the first combo I can delete the record but if I also
choose from the list in the second combo I get the above error message.

The master and child link properties are fine but I cant think how to
resolve it.
 
Ã

Özcan ELMALI

Hi,
if your query has 2 Related Table you can not Delete or Add Record(s). But
if you write "in(select * from tble_Ccode)" in the Criteria, you can delete
Record(s), if record(s) be in tble_Ccode.

If you want the Sample, you can write me, [email protected]

BestRegards
 
Top