This content has been marked as final. Show 2 replies
Create a value list based on the Client Name field in the Clients table. On the layout based on the Jobs table, use the 'Client Name' field from the Clients table, and apply the value list to the field. If you select a client that is already existing, it should not create a new record in the clients table.
Thanks for the reply, I've just tried it out and first one created a new record, I commited the change and tried creating a new Job record with the exisiting client name, undortunately it didn't work. I must have an incorrect setting somewhere on the field descriptions, I'll check these again and see if I've done something really silly. In the meantime if anyone has any other suggestions or things I should check that would be great. Thanks!