Brand New To FM w/1st question

[Who Me?]

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 December 2, 2006 by Guest

[Genx]

Hi there and welcome to the forums.

Before I try to help... What's the reason you want to keep the duplicate and do you want table 2 to update whenever table 1 updates?

[Ender]

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".

[Genx]

Yeh,

What Ender said -- listen to him -- he's smart :B

[Who Me?]

Wow, how easy...I was trying to set it up compeletly in the wrong direction.

Thanks so much!

Brandon