Seems simple enough. It would be easy for me at least.
But you may need to take a step back and think about tables and relationships first.
Note that a database and a layout are two very different things.
"database" suggests that you have two tables, One is called proposals and stores your leads. But what is the purpose of the other one?
It's not impossible that you really only need one table with a field whose value distinguishes between a "Lead" and whatever you choose to call your "awarded" records.
Yeah the terminology is mixing me up a bit..lol
So, yes the proposals will store my leads and the other if awarded will store more detail information about the job that would only be filled out if I'm awarded the job.
But, I would like the basic information carried over to the other one when I click on awarded, so I don't have to fill all that out again.
I just purchased Filemaker Pro 15, I was stuck on version 5 for years. lol.
sounds like a proposal has many states so perhaps a simple field in your proposals table would suffice to track the current state of a proposal?
You can add a related table for those additional details so that the contact data stays in Leads. When the record's status becoNed "awarded" you then add the related record and fill in those details