Jump to content

Brand New To FM w/1st question


Who Me?
 Share

This topic is 5779 days old. Please don't post here. Open a new topic instead.

Recommended Posts

Hello,

I am very new to FM and I have a question which I am sure is so simple, however I cant find the solution anywhere.

I have created two tables, I want to enter data into table #1 and have it also fill in table #2.

I want to be able to delete the data from table #1, yet have the data in table #2 remain, I guess what I want is a record kept of the data from table #1 even though it has been deleted.

Could someone point me in the right direction? Sorry if this is not the beginners section...could not find any area for new kids on the block.

Thanks for any help.

Brandon

Edited by Guest
Link to comment
Share on other sites

Hey Brandon,

Using a table of duplicates for this purpose would be a mistake. It's better to use only one table and not allow the user to actually delete the records. Instead give them a button to 'Delete' that runs a script to mark the record as "Deleted" by setting a field. You would then need to filter your Finds and relationships to exclude those that are marked "Deleted".

Link to comment
Share on other sites

This topic is 5779 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.