Unable to Update record on Table.

[fernandezd]

Hi all,

I have a table called brokersdetails (master table)
Another table has a field from this table called brokersname assigned to it.

This brokersname field has been indexed with no duplicates.

I need to be able to Edit this information and not get an error message...!!!

I currently try to change the brokersname field and it says "

Cannot update 1 record due to lock violations.

Can anyone tell me how to please change this field without having this error.

Thanks FernandezD
At your service.
Unix systems Admin

 

[petermeachem]

What's this mean?
Another table has a field from this table called brokersname assigned to it.

Are you editing brokersdetails directly, or in a query with another table?

Peter Meachem
peter@accuflight.com

Support Joanna's Bikeathon

http://www.accuflight.com/blue_peter_bikeathon_2002.htm

 

[zambezibill]

Fernandez,

The preceeding questions from Peter where right to the point, but something else about table structure comes to mind.

Sounds like you have set up two tables with a one-to-one relationship. That being the case, is there any particular reason not to combine into one table?

Cheers, Bill

 

[fernandezd]

Thanks..

I have two tables called

CustomerDetails and BrokersDetails.

Customers are assigned to brokers and therefore need a relationship with the brokers table.

The relationship it one to many not one to one.

The name of the broker needs to be updated via an edit button (open form and record under edit mode).

When chaning the name the record does not save at all. So my edit button does not work.

I have tried docmd.save
and using sql to update the record but it just says that it cannot due to permissions on this table.

Any Ideas ?? FernandezD
At your service.
Unix systems Admin

 

[fernandezd]

Hi.

Any Answers on this question please !! FernandezD
At your service.
Unix systems Admin

 

[WildHare]

Your relationship is ONE Broker to MANY customers, right?

The QUERY that joins them and and displays the form full of customer data should have the broker name guy included (or else how does he display on the form, right?)

Perhaps the easiest way to do this is set the BROKER NAME field in the CUSTOMER table to a LOOKUP guy that displays the BROKER names from the broker table.

Go to the Customer table design, click the broker name field, and then in the properties pane, click the LOOKUP tab. Set the rowsource type to TABLE/QUERY, set the Recordsource to your BROKER table name field, and set the control type to COMBO BOX.

You should be set to go.

Jim How many of you believe in telekinesis? Raise my hand...
Another free Access forum:

http://www.forumco.com/jmhare

More Access stuff at

http://www.jmhare.com/wildhare2.htm