Hi,
First the add form, I need to verify one of the field against a column and make sure the value equal to at least one value in that column before allow user to save the data. Otherwise, new data will not show up because the "where" clause joinin two tables.
Second, I have some record that miss one column, when I try to edit it, it give me a blank screen like the add screen instead of let me edit the old record.
Please help.