G
Guest
Hi
I am new to Access and need to design an contact database. I have 3 tables -
Contact details, Investor details and Visit Reports. They all contain the
same companies but not all of the ones in Contact Details will have an entry
in Investor Details (some will be standard contacts and some will be
potential investors and so I need additional info on them) but when I look at
the Investor details I need to see the address and country but this is in
Contact details and so I know I shouldn't duplicate? How do I view this info
in Investor Details?
Also - we have several contact names per company and so I want to have a
subset of all the individuals by company in the Contact Details table - how
is this done?
Many thanks in advance - sorry for the poor explanation
I am new to Access and need to design an contact database. I have 3 tables -
Contact details, Investor details and Visit Reports. They all contain the
same companies but not all of the ones in Contact Details will have an entry
in Investor Details (some will be standard contacts and some will be
potential investors and so I need additional info on them) but when I look at
the Investor details I need to see the address and country but this is in
Contact details and so I know I shouldn't duplicate? How do I view this info
in Investor Details?
Also - we have several contact names per company and so I want to have a
subset of all the individuals by company in the Contact Details table - how
is this done?
Many thanks in advance - sorry for the poor explanation