I will definitely try this.. acutally, I recall coming across a code that made a button click that automatically duplicated the record and saved changes to it as well..?
On a side note, the next step of the project is to have forms pop up, or tabs or something to fill out when a certain button is checked (so that's easy enough, i think per our previous discussion and the forums here). However, my problem here lies not so much in the construction but the organization of the DB.
The database is designed as follows and i have attached a screen shot of the main page...
The Stat audit Y/N check box makes the fields on the right pop up with all the audit requiements (thats what we had worked on), though still get that invalid use of null (ill try your suggestion)
The next issue is the "tracking interests" section of the form.
As you see below there is a checkbox next to each parent company. What i need to have happen is when i click lets say parent 1's tracking interest box, another form/tab/something, pops up that makes the user fill in data on that relationship.
The relationship is defined as the parent's other interest (besides the % listed) in the "entity" in other words, Entity 1's interest in Entity 6 (i have this form made just need to figure out how to organize it)
When the record is duplicated, i would need both the record itself, as well as the sub forms for example Entity 1's interst in 6 entity 2 in 6 and 3 in 6 etc (if checked)... so not sure the proper organization..
not sure if i'm explaining this all well, but i figured if anyone knows this stuff its you guys. Thanks again!
