Hi,
i want to create a form similar to the screenshot,
One (databasejoin) dropdown,
& a button that autofills a field according to the dropdown & at the same time deletes the original record from the table that the autofilled data originated from.
What i'm interested in, is every autofilled data entry to be used only once and by one user. (If there are two or more users online at the same time they never get the same autofilled data.)
(Maybe it would be more practical to flag the original entry with a hidden 'used' field instead of deleting it?)
Any ideas?
Thank you
i want to create a form similar to the screenshot,
One (databasejoin) dropdown,
& a button that autofills a field according to the dropdown & at the same time deletes the original record from the table that the autofilled data originated from.
What i'm interested in, is every autofilled data entry to be used only once and by one user. (If there are two or more users online at the same time they never get the same autofilled data.)
(Maybe it would be more practical to flag the original entry with a hidden 'used' field instead of deleting it?)
Any ideas?
Thank you