Hi All
Hope you will be keen on sharing your experience and suggest what is the best practice in recording names.
I have currently [First Name] and [Last Name] separately in tblClients and use concatenate query to get a Full_Name.
In other table where we record service provided to clients I use combo box with lookup to get the Full_Name and record service provided to particular client.
I feel that often restricts functionality as there is no direct relationship between those two tables only via query(e.g. can't create one-to-many between tblClients and tblActions). I'm trying to work out if I should stop splitting name in Clients table. I'm only afraid this can cause other issues, like not being able to sort clients by their surname, etc.
Perhaps there is an easy solution to that, but I'm lacking imagination and knowledge here :-/ Hope you can help.