I have a "main" table, call it A. It holds client names. I have a second table, call it "B." It will hold deadlines. For every A record, i.e. client, Table B should have one corresponding record where a lookup field (call it "Name") populates with the "Name" field in Table A. Then Table B holds deadlines specific to each "carried over" or "mirrored" record from Table A.
It should be that when a record is created in A, a corresponding record (assuming auto-number-generated?) would be created in B, with the name lookup from A. Then deadlines get logged in Table B, and an interface created to allow viewing of deadlines and other things from various other tables for the various clients in Table A. But Table A is the master table.
The aim is to have sensible table size (one giant table with every imaginable deadline would be unwieldy) but not have to manually create Table B Deadline records for every Name/Client in Table A.
Many thanks for any help!
