I think the problem occur when two user entering data in the table because of the primairy field
It's the only time I have seen something like this
if it's that you can create another table on access to store the value and after make the update
if it's not the problem mail me with the exact...
I try to use 2 table in a form but I must refresh to have the right values in one field for example :
I give the number of dept of customers and I want to have the name in the other field but it never works :-(
I have this problem with many forms also...
I can do this with sqlserver 2000 but...
If i understand exactly how sqlserver run it's possible but i never can make this with a big DB also it's not a problem because the backup is too quick and we don't have a real difference for the user !!!
Also be careful test it with enterprise (the standart version can't do this)
Regard flany
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.