Need some advice and help

[winterh]

At the moment my users have a drop down list on one table with company names only, and I have a second table with the same list of names and the full address.

So when a user picks a company from the drop down list and press a buttion a query runs to do a letter with the name and address, I have done this by using a linked Query on the company name of both tables as this is the same.

The problem I am having is if one user is selecting company 1 and a second user selects company 1 at the same time the database brings a message up along the links of "table locked".

Do you have any idea of a better way of doing this, to keep it simply one table have a list of names and a second table has the name and full address.



Cheers

Hads

[ssanfu]

Is the database split into a front end (FE) and a back end (BE)?
Does each user have a copy of the FE on their computer?

[winterh]

Yep the thing is split to front and back

[ssanfu]

And each user has a copy of the FE on their computer??

[winterh]

Yep every user has a copy of the FE and each user is linked to the same BE

[ssanfu]

I haven't seen that behavior. Maybe it is a trust issue with Win 7/AC 2010.

Question: why two tables: names and name and full address?? Doesn't that defeat the purpose of a relational database?

[winterh]

Sorry I am a little new to access, I thought I had already done that as I am using the name from the drop down and then cross ref via a query from the other table to get the details.

If this is not right (sounds like it is not) would you be able to give me some advice or point me in the right direction.

Thanks

Hads

[ssanfu]

What are your two table structures? Since the names are in both tables, all you need is the one table with the names and addresses. Does one name have more than one address? Then you could have a table of names and a table of addresses - but there would be a foreign key to link to the table of names rather than storing the names in both tables.

Here is a link to some basics

http://www.accessmvp.com/Strive4Peace/


Look at chapters 3 & 4

[winterh]

If I explain what I am trying to do it may help with theanswer.

I have one table which holds most of our customer details;this table also includes a drop down list of all the company which we need tosend letters to for our clients.

On a second table I have all the Names and Address forthe companies.

As soon as one of the staff pick a name from the dropdown list on the form and press send the database runs a query which pulls theclients name and details and the details for the provider which has a linkedquery for the drop down and the name and address query.

Hope this helps, as I have started to get users sayingwhen they select from the drop down the database is saying “field is locked”.

If you have any better way of doing this please let meknow.

[winterh]

Thanks I have sorted it I think :-) I have done a new table with all the name and address and linked it to the main table. Thanks