V
VTM3
Using the Field List pane, I dragged the primary key field of my 'one' table
to the datasheet view of my 'many' table. Then I went to the 'show
relationships' tab and double-clicked on the line between my two tables. A
box popped up showing the one-to-many relationship where I checked the
referential integrity box and both the cascade boxes, however, when I press
ok, an error message says that someone else is using the primary database and
that it must be locked before this operation can be performed.
No one else is using the primary databse. I have it open because I had to
drag a field from another table into it. How do I lock this database in
order to allow this operation to proceed?
thanks,
vtm3
to the datasheet view of my 'many' table. Then I went to the 'show
relationships' tab and double-clicked on the line between my two tables. A
box popped up showing the one-to-many relationship where I checked the
referential integrity box and both the cascade boxes, however, when I press
ok, an error message says that someone else is using the primary database and
that it must be locked before this operation can be performed.
No one else is using the primary databse. I have it open because I had to
drag a field from another table into it. How do I lock this database in
order to allow this operation to proceed?
thanks,
vtm3