Shared serial number between tables.
I have Table A, which has a parent/primary key used for related records of docKeyA (Table A sub A, Table A sub B, etc.), I have Table B which has a parent/primary key used for its related records of docKeyB (Table B sub A, Table B sub B, etc).
Table C is one that will have records that are related exclusively to Table A, as well as records that are related exclusively to Table B. Table C will be child records of both Table A and Table B. My issue is that docKeyA and docKeyB are Auto-Entered Serials, so when Table C inherits the docKey from Table A or Table B, there will be duplicates. How can I avoid this?
I assume there will be some way to use a Get(UUID) as the docKey, but I still need to have an easily identifiable number to identify each record in Table A, B and C... (like, 1, 4124, or 12,234). Is there a way I can set up another table that Table A and Table B query to get the next number in the series? This seems like the best course of action...
Thanks for your replies!!