I'm just getting started an I have some questions on tables.
I deal with both companies and end users and I'm trying to figure out how to
set up the contact table. My plan was to set one table for companies and have contact entries as a sub form and another form for contacts with individuals but both the company contact sub form and the individual form would link to the same table? My reasoning is that I may have many contacts to one company but have individuals that contacts normally at most would be "domestic partners"and their family members and I want to track contacts whether it's email, phone calls, letters and more. The first question on my form would be which kind of contact would I be working with and bring up the correct form. I know that this will be the first of many questions. Marc |
Hi Marc
This sounds to me like "one-to-many-relations". Excel doesn't do that very well. A database program will do this far better. If I understand this right, that is. Excel is a spreadsheet. HTH. Best wishes Harald "Marc" skrev i melding ink.net... I deal with both companies and end users and I'm trying to figure out how to set up the contact table. My plan was to set one table for companies and have contact entries as a sub form and another form for contacts with individuals but both the company contact sub form and the individual form would link to the same table? My reasoning is that I may have many contacts to one company but have individuals that contacts normally at most would be "domestic partners"and their family members and I want to track contacts whether it's email, phone calls, letters and more. The first question on my form would be which kind of contact would I be working with and bring up the correct form. I know that this will be the first of many questions. Marc |
My bad I thought I was posting to the Access group!
Marc "Harald Staff" wrote in message ... Hi Marc This sounds to me like "one-to-many-relations". Excel doesn't do that very well. A database program will do this far better. If I understand this right, that is. Excel is a spreadsheet. HTH. Best wishes Harald "Marc" skrev i melding ink.net... I deal with both companies and end users and I'm trying to figure out how to set up the contact table. My plan was to set one table for companies and have contact entries as a sub form and another form for contacts with individuals but both the company contact sub form and the individual form would link to the same table? My reasoning is that I may have many contacts to one company but have individuals that contacts normally at most would be "domestic partners"and their family members and I want to track contacts whether it's email, phone calls, letters and more. The first question on my form would be which kind of contact would I be working with and bring up the correct form. I know that this will be the first of many questions. Marc |
All times are GMT +1. The time now is 11:16 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com