Recordset Not Updateable

[johnnyc]

Hey Guys,

I have a split database....

In the front end, i have a form that connects a bunch of tables. My issue is that because 2 of the tables are a One to many relationship, it is making my form read only.

These 2 tables are linked from the back end database.

Table1 = MainT (has datasource primary key multiple times)
Table2 = DataSourceT (Has Primary Key linking the two)
Table3 = CorrectionT (has datasource primary key multiple times)

assistance would be greatly appreciated!!!!

 

[CJ_London]

rather than having a single form/multi table recordsource, have a mainform for the one side of the relationship and put the many side into a subform - one table, one form