dennismoorejr

Create Record triggers creating a record on another table to populate a field.

Discussion created by dennismoorejr on Nov 4, 2017
Latest reply on Nov 4, 2017 by philmodjunk

I am curious if the LET command can accomplish an idea I am looking to complete.

 

I would like to create a table (Table A) which generates invoice or transaction numbers.  I would like a separate table (Table B) to take an invoice number from (Table A) in its field "invoice number".  I would also like Table C to accomplish the same as Table B.

 

I am thinking along the lines of creating records in Table A that I could populate a field on Table B with a foreign key and associated table.  I would creating a new record in Table B to trigger or create a new invoice number in Table A.

 

Ideally Table A would have records that consist of records which auto create serial with fields which are triggered when a record is created in Table B or Table C

"MasterInvoiceYearPrefix" = AutoEnter Data Cant Modify "2008"

"MasterInvoiceNumber" = AutoEnter Serial Number Cant Modify starting at 0001 etc...

"MasterInvoiceYear_Number = Calculation = InvoiceYearPrefix & "_"  & InvoiceNumber

 

Table B

Create a record which would have a field

"TableBInvoiceNumber" = this would be taken from table A and display 2018_0001 and so on.

 

Table C

Create a record which would have a field

"TableCInvoiceNumber" = this would be taken from table A and display 2018_0002 and so on.

 

Table B & Table C record create would create a record on Table to be used.

 

Hmmm..My heard hurts..

 

Table Z (Members of Book Club)

Table A (Master Invoice/Transaction)

Table B (Book Club Member Dues)

Table C (Fines for Late Books)

Table D (Purchase of Books)

 

I make all transactions for Fines / Member dues in Table B, All Member Dues in Table C, and purchases on Table D.

Outcomes