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.
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.