AnsweredAssumed Answered

Shared serial number between tables.

Question asked by episking on Feb 24, 2015
Latest reply on Feb 24, 2015 by episking

Title

Shared serial number between tables.

Post

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!!

-EP

 

 

Outcomes