Sorry this is lengthly.....

I have made a simple Customer Database (Company, Name, Address, etc.)

I have made a Job Ticket Database that picks up information from my Customer Database.

Sometimes, under one company, I have multiple contacts, but the autofill in the job ticket will pick-up the company and USE the first contact alphbetically. I am unable to get to the next contact in the list under the same company.

First, any suggestions?

I have tried to make a client ID cell. So where as I can type a code for the company and get all info, but this only works if I do enter everything this way. I can not fiqure out how to be able to automate input using (2) differnt methods simotaneously. I hope that made sense.

I am currently changing Company Names (Ex. The ABC Company_01, The ABC Company_02, etc.)

This seems to be the only logical way to retain the appropriate contact to the company, but it just seems there is a better way.

Any thoughts would be greatly appreciated!

Thanks,

Mike

This is 2NF which in filemaker pre 7.0 has to be done by unstored fields to avoid redundant info ...I've made a template that takes care of mixing companies with persons not being inrolled in a company.

I've included a portal from Contacts to show which tasks they've been assigned to ...as another view. But the actual business by chosing people to a task is done by clicking in the DoneBy field that opens a popup listing all posible...

--sd

Attempt2NF.zip