D
Dale Laurich
Hi,
Im trying to set up a DB with three tables. Table1 has an autonumber
for the PK and Table2 and Table3 each have a field named ID "long
integer". Relationships set up from Table1 to Table2 and Table1 to
Table3 each with ref integrity enforced with both cascade update and
delete. I've tried to set up a form for data entry but when I
attempt to enter a record I get "You can't add or change a record
because a related record is required ing 'Table1'".
I have my record source equal to all the fields in all three tables
and use the following join statement.
FROM ([Table3] INNER JOIN ([Table2] INNER JOIN [Table1] ON
[Table2].[ID] = [Table1].[ID])ON [Table3].[ID] = [tblTable1].[ID]):
Any help or suggestions would be greatly appreciated.
Thanks,
Dale
Im trying to set up a DB with three tables. Table1 has an autonumber
for the PK and Table2 and Table3 each have a field named ID "long
integer". Relationships set up from Table1 to Table2 and Table1 to
Table3 each with ref integrity enforced with both cascade update and
delete. I've tried to set up a form for data entry but when I
attempt to enter a record I get "You can't add or change a record
because a related record is required ing 'Table1'".
I have my record source equal to all the fields in all three tables
and use the following join statement.
FROM ([Table3] INNER JOIN ([Table2] INNER JOIN [Table1] ON
[Table2].[ID] = [Table1].[ID])ON [Table3].[ID] = [tblTable1].[ID]):
Any help or suggestions would be greatly appreciated.
Thanks,
Dale