Arg81
Well-known member
After having to change my structure of my project, I have a small problem.
Now when the Sales team go to add a new record, they will not be adding any child data.
Therefore I have set up a simple data entry form to allow them to enter data into the "master" table.
Then our R&D department will be doing the work that enters into the "detail" table (or child, however you want to say it).
When I use any of my search forms, I.E. ID Number, Customer etc which use a parameter, the data retrieves OK from the master table.
However, when I go to add a record to the "detail" table (DataGrid), I get the error "Rev_ID cannot be null".
My child table has a joint ID, DWR_ID and Rev_ID. Neither are set to Identity fields in my SQL table, Rev_ID is a manually entered field which goes on logic of a sequence, whilst DWR_ID is the ID that relates to the master table.
Any help much appriciated.
cheers,
Luke
Now when the Sales team go to add a new record, they will not be adding any child data.
Therefore I have set up a simple data entry form to allow them to enter data into the "master" table.
Then our R&D department will be doing the work that enters into the "detail" table (or child, however you want to say it).
When I use any of my search forms, I.E. ID Number, Customer etc which use a parameter, the data retrieves OK from the master table.
However, when I go to add a record to the "detail" table (DataGrid), I get the error "Rev_ID cannot be null".
My child table has a joint ID, DWR_ID and Rev_ID. Neither are set to Identity fields in my SQL table, Rev_ID is a manually entered field which goes on logic of a sequence, whilst DWR_ID is the ID that relates to the master table.
Any help much appriciated.
cheers,
Luke
