I have two tables:
client(id, name, markup)
forecast(id, client.id, client.markup, total)
I have created a form on the second table, forecast.
The client can be selected by means of a combox from the first table, client.
Now I would like the corresponding markup to appear in the client.markup field.
I have tried with an expression:
but it does not work and a get an error: #type!Code:=DLookUp([client]![markup];[client];[client]![ID]=[client])
Any suggestions? thanks