History

[tug]

i Have designed a database for a friend who runs a small computer shop, it is for him to use to enter customer names adresses and the fault, solution, parts and price. he wants a box or button that will allow him to see if that customer has been in before and their previous faults. i have found a medical template the uses this but it is loocked so i can not see how it is done. any help would be gratefully appreciated

[tug]

NEWBEE

[agtjazz]

Can you set up one of the fields (perhaps phone number) as to not allow duplicates?

That way, if the user enters a phone number that is already in there, it will beep at the user and provide a clue that this customer already exists.

And if the customer already exists, you can do a portal for all their transactions.

BTW- do you have a structure of the database? The clients should be in a separate table from their transactions.