i have a basic fmp file with 2 tables. they relate via a job number. in my job specs table, i have a portal which shows fields from my schedule table.

once a job has been billed and closed we can remove it from the job schedule which i created a delete record button for. i want the portal in my specs table to not be effect from the record deleted in my schedule table. i unchecked the area in my relationship which states "Delete related records in this table when a record..." this still removes the information in my portal. Can someone please advise me to how to delete a record and KEEP all that information in a portal? its killing me here. :

i want the portal in my specs table to not be effect from the record deleted in my schedule table

But the portal shows related data, and if it's gone can't it be shown any more! But you would probaly miss a table more in beween the two, where to the data is saved via lookup!

--sd