HI all,
I need to update the ClientName field that is currently empty on one of the tables on my database using the ClientName field on the Clients table, I have been looking online but I'm not sure the best way to do it so any help with how to create the query would be appreciated.
Table layouts
Table 1 - tblClient
ClientID (Auto number field - Primary key)
ClientName (Short text field)
Plus a selection of other short text fields for the address etc
Table 2 - tblClientContacts
ClientContactID (Auto number field - Primary key)
fkClientID (number field - joined to the ClientID field on tblClient)
ClientName (Short text field that is currently empty, this is the one I would like to fill)
ClientContactName (Short text field)
Plus a selection of other fields for phone number, mobile number & email address etc
How would I write a query to copy the ClientName from tblClient into the ClientName field on tblClientContacts?
Thanks in advance
I need to update the ClientName field that is currently empty on one of the tables on my database using the ClientName field on the Clients table, I have been looking online but I'm not sure the best way to do it so any help with how to create the query would be appreciated.
Table layouts
Table 1 - tblClient
ClientID (Auto number field - Primary key)
ClientName (Short text field)
Plus a selection of other short text fields for the address etc
Table 2 - tblClientContacts
ClientContactID (Auto number field - Primary key)
fkClientID (number field - joined to the ClientID field on tblClient)
ClientName (Short text field that is currently empty, this is the one I would like to fill)
ClientContactName (Short text field)
Plus a selection of other fields for phone number, mobile number & email address etc
How would I write a query to copy the ClientName from tblClient into the ClientName field on tblClientContacts?
Thanks in advance