>I have a 'form'(master-detail) that run on network,
>If there are 2 or more run 'form' to input data at the same time,
>then occuring error "...invalid key..." or the key is invalid between tables(master-detail)
>What can i do to solve this problem ?
I think this is because you are assigning the same primary key in both forms.
What you can do is creating a keynumbers file where you store the keynumber to be used.
Each time you need to create a new record, you look into this file first, get the value out of it, and replace the value with value + 1
In the Tasmanian Traders example is a sample of this in the NewID function.
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only