Help with some Logic

Discussion created by arthursc on Dec 25, 2011
Latest reply on Jan 5, 2012 by Mike_Mitchell



I need some help with a bit of logic. My scenario is thus;


Table A (Species) lists deer species. This is a read only table pre-populated and for this reason I do not want users to add or delete or amend this table.


Table B (Culls) lists details of culls. In this table I need to list the "species" culled selected from the table above but inserted from the table below.


Table C (Outings) lists outings a hunter may have done. This is where logging happens, Deer culled, sex, condition, wind direction etc.


The issue I have is that As Table A is read only, I cannot add the species to Table B from a Related field in Table C.


Is the best way to just created a "species_cull" table or find a better method.


Kind regards