Interactive job ***

Hi, new to this group and new to Access.

I work for a water filtration company here in South Australia, our
customers are in MS Access.

Each day I am faxed a "Job ***" for the following days work with the
customers: Name: Address: Phone No.: and the Filter System they have.

Now my question:

Can the "Job ***" be generated by
1/ Going into the customers record
2/ Clicking on the Phone No (Its the only unique field)
And the record goes onto a "Job ***"
Then, the process is repeated until the "Job ***" is populated,
whether its with 2 jobs or 10 jobs?
.

Quantcast