Nothing drops, the Cancel button does what it is supposed to. Just the submit
new record is messing up with the ID setting to 0.
if i read your code correctly, pressing your Cancel button should
actually trigger the INSERT query on your action page, since
form.proj_OK will not be defined then...
"submit new record" is not messing up with the ID value in any way: the
ID is set to 0 by your code i posted in previous message: form.ID =
variables.ProjectID = url.ID (default = 0)so if url.ID is not defined,
then it and all other vars are set to 0. and i assume when you are
adding a new record no url.ID will be defined...
How about this, in my DB there are 2 tables. the Categories table, and the
In the Categories table, CategoryID is set as auto number, and the primary
key. In the projects table, projectID is set to auto number and also the
primary key. Now there is also a cell in projects to place the CategoryID, but
that is only set as number. Will this mess anything up? Lets say the first
categoryID in the Categories table is 1, if i am to add a record to Projects,
and the projectID is 1 and when I add a new record and use the categoryID that
is 1, will that cause a problem?
no, it won't, unless you make it cause a problem :)