T
Travis
I am doing a database which keeps track of assets owned by people,
companies and trusts.
Each person has an autonumber Person ID.
Each company has an autnumber Company ID
Each trust has an autonumber Trust ID
The information I require about these three types of "entity" are
different, so I've got a person table, a company table and a trust
table.
There is another table which has the asset information.
Every asset is owned by an entity and hence the asset table has Asset
ID owned by Entity ID.
Another table has the primary key Entity ID and the second column is
"Type" which could be "Person" "Company" or "Trust" and a third column
which has the Person ID, Company ID or Trust ID.
Obviously I can assign a person, company or trust an Entity ID with
autonumber and manually enter the information in the second and third
columns, but that's a waste of time.
How could I set it up so that every time I create a new person, company
or trust these get added to the other table and assigned an Entity ID
automatically?
Thanks in advance for your help.
Travis
companies and trusts.
Each person has an autonumber Person ID.
Each company has an autnumber Company ID
Each trust has an autonumber Trust ID
The information I require about these three types of "entity" are
different, so I've got a person table, a company table and a trust
table.
There is another table which has the asset information.
Every asset is owned by an entity and hence the asset table has Asset
ID owned by Entity ID.
Another table has the primary key Entity ID and the second column is
"Type" which could be "Person" "Company" or "Trust" and a third column
which has the Person ID, Company ID or Trust ID.
Obviously I can assign a person, company or trust an Entity ID with
autonumber and manually enter the information in the second and third
columns, but that's a waste of time.
How could I set it up so that every time I create a new person, company
or trust these get added to the other table and assigned an Entity ID
automatically?
Thanks in advance for your help.
Travis