Crazy things going on - delete all of the notes it clears all the check boxes?
I created a simple 5 table db on FMP
Scopesheets
Ceiling
Walls
Flooring
Cabinets
right now I only have scopesheets with a relationship to ceiling.
this is the relastionship
I can start to input info without any problems.
I can input notes, with the time and date stamps without any problem.
But if I delete all of the notes it clears all the check boxes...
Very crazy, cant understand why it's doing this...
Can someone please help me to how to fix this and why it is happening so that I don't make this mistake again.
Respectfuly
J.Pineiro
data-inout.png
Screen-Shot-2018-01-15-at-4.05.23-PM.png
Scopesheets
Ceiling
Walls
Flooring
Cabinets
right now I only have scopesheets with a relationship to ceiling.
this is the relastionship
I can start to input info without any problems.
I can input notes, with the time and date stamps without any problem.
But if I delete all of the notes it clears all the check boxes...
Very crazy, cant understand why it's doing this...
Can someone please help me to how to fix this and why it is happening so that I don't make this mistake again.
Respectfuly
J.Pineiro
data-inout.png
Screen-Shot-2018-01-15-at-4.05.23-PM.png
Will Loving
Which table are the checkbox fields in? They should be in scopesheets if you want to retain their values. If they are in the related ceiling table, which sounds like it's actually a Notes table, they will be associated with the first Note and will disappear when you delete the note.
ASKER
Hi Will
I just started to redo the db, thinking it was a something that went wrong.
Hoping more then anything that will would correct itself if I started over.
To my disappointment its still doing same.
To answer your questions
on this DB there is only 2 tables Scope sheets andCeiling
On the scope sheet I created a tab control in that tab control I inserted a portal that points to ceiling.
same thing if I delete all notes on the portal it deletes the info checked of which is part of the ceiling table also....
Will...
Are you saying I need to have a notes table so that this will not occur?
I just started to redo the db, thinking it was a something that went wrong.
Hoping more then anything that will would correct itself if I started over.
To my disappointment its still doing same.
To answer your questions
on this DB there is only 2 tables Scope sheets andCeiling
On the scope sheet I created a tab control in that tab control I inserted a portal that points to ceiling.
same thing if I delete all notes on the portal it deletes the info checked of which is part of the ceiling table also....
Will...
Are you saying I need to have a notes table so that this will not occur?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thank Will that worked !
ASKER
Thanks Will that worked.