Temporary Table

[Marvin J]

I'm Developing a Cash-Register type database... and I need the user to be able to enter the data, and be able to edit this until he/she clicks a 'Complete Sale' button. Then this information will be entered into the actual database. If a record needs to be edited, a manager with the correct name/pass can access the main table and edit the record.

Any Ideas on where to start on this one??

I was thinking of using a temporary table to pull in the information, when the button was clicked the info would be transferred to the actual database, and delete the temporary record, and ur back to square one... Problem with this is I'm stuck as how to transfer the record over. Any help whatsoever would be greatly appeciated.

Thanks,

Marvin J

[RalphL]

Since you are using FMP7 you could set it up to not commit the record until the complete sale button is clicked. This elminates the need for the temporary table.