First table category
field 1 id
field 2 category
field 3 key1
second table activity
field 1 id
field 2 activity
field 3 key2
third table tasks
field 1 id
field 2 categoryid the lookup returns key1
field 3 activityid the lookup returns key2
field 4 keycode
field 5 task
when adding new tasks i lookup the category and activity in table 1 and 2
I want to pre populate keycode from keycode = key1 + key2
how do you accomplish this .
I'm open to the idea of not using a lookup a pre-defined list woul do.