Forum Discussion
DonLarson
5 years agoQrew Commander
Muhammad,
I agree with Ryan. I have had this happen a number of times as business process rules grow. Tables that were created years ago with a hand full of demographic data now have a hundred fields and several new parent tables. Going back and clicking edit on old data means that you have to update all the required fields now in order to change or update one piece of information.
So to get around this, make a list of the currently required fields.
Go to the table properties and clear the check box for the requirement
Reset them to required after your import.
This is very clugy way to get it done but the data will load.
------------------------------
Don Larson
------------------------------
I agree with Ryan. I have had this happen a number of times as business process rules grow. Tables that were created years ago with a hand full of demographic data now have a hundred fields and several new parent tables. Going back and clicking edit on old data means that you have to update all the required fields now in order to change or update one piece of information.
So to get around this, make a list of the currently required fields.
Go to the table properties and clear the check box for the requirement
Reset them to required after your import.
This is very clugy way to get it done but the data will load.
------------------------------
Don Larson
------------------------------