I am an IT placement student working for a wildlife charity for one year.
I have a table of 20 species. Each row contains some information on a single species. I want to add functionality to add a new species. That is easy.
I have another table which is for the legislations that apply to each species. Each species is used as a field name in the legislation table and there either exists a 'Y' in its cell relevant to each legislation, or a null.
Can I write code/create a macro or expression to add a new species to the species table, which will automatically generate a new column in the legislation table, and also to generate a new field in the 'add legislation' form?
If this is possible, can someone give me a few pointers on how to achieve it?
Thanks,
David
I have a table of 20 species. Each row contains some information on a single species. I want to add functionality to add a new species. That is easy.
I have another table which is for the legislations that apply to each species. Each species is used as a field name in the legislation table and there either exists a 'Y' in its cell relevant to each legislation, or a null.
Can I write code/create a macro or expression to add a new species to the species table, which will automatically generate a new column in the legislation table, and also to generate a new field in the 'add legislation' form?
If this is possible, can someone give me a few pointers on how to achieve it?
Thanks,
David