Hi there, i have 2 tbls.
tblRepair
tblNotice
First i fill the repair form, then when the guys repair it, he fills
click on the Notive form, enter the ID of the repair form he received
and fields like client name, problem, etc... fils up
automatically.(using a criteria)
the 2 tbls r link with ID (a unique ID so i can trace them)
my problem is: when the guys enter the Notice form, he enter the ID
number, then he fills the date field and the ID goes back to 0 when it
should be the same number he entered. He has to enter it manually when
he is not suppose.
anybody knows how to fix it??