I hope it's the right place to ask this.

I'm having a little bit of a problem with a database: users get "cannot modify this record, it's already in use by..." when they try to create a new record in a portal.

Well it's a bit more complicated:

- I have a layout showing the one and only record from a table called ProjectCenter (almost all the fields are Global in this table an thus they can be modified by anyone at any time).

- On this layout, except for one field from that ProjectCenter table, the other fields are from a related table and they show project details.

- On this same layout there's a portal showing records related to the project.

- When someone's trying to add a record using that portal they get "record in use".

How come? isn't the new record in the portal a "new record" so it can't possibly be in use by someone else.

When you edit a portal record, the parent record gets locked as well.

I'd suggest you rework your structure so that each user gets their own parent record, or change the interface so that all the editing happens in a layout based on the related record.

It should also work if you use only globlas for the parent key in the relationship to the child table.

Edited September 27, 200619 yr by Guest