Populate one table from another

[peterdeep]

Hi, a very very newbie here. I am creating a customer database and that seems to be going well. I also want to keep track and record when a customer visits and be able to review that log of their visits later.

I have a table 'customers' where I can enter a customer's information and perform a find. Once found, I want to hit a 'next' button that will log the customer's visit, preferable on my table named 'log' which has two fields: customer serial and a timestamp.

I have the button which brings me to the 'log' table but I can't figure out how to auto-enter the customer's serial number into that table. Ideally, I would then like to hit another button and return to the 'customer' table in find view. Any ideas?

Thanks!

[comment]

See if this helps:

http://fmforums.com/forum/showtopic.php?tid/198516/