Field Default Value

[craigjjs]

I am creating a database for my own company to manage client trademarks. There is a table of clients and a table of trademarks. One of the fields in my trademarks table is an "Owner" field. The Owner is usually, but not always, the Client. I would like the Owner field to have a default value that is the contents of the corresponding Client in the client table. I do not presently have a Client field in the trademarks table, only the client number (autonumber) as a foreign field. I have tried using the expression =[Client] in the default value property sheet, but it does not work.

Does anyone have any suggestions as to how I can make the default for the Owner field int the trademarks table be the contents of the Client field in the clients table?

Thank you.