Recent content by LAM

Thanks for the input. This calculation would only be a portion of a larger database that we use to track a major business process including contracts, clients, etc. Currently all of this is being done in Excel and it is very cumbersome, especially since so much of the information is used over...

I am looking for some direction on how to set up the following. We need to compute a final premium amount based on multiple factors. The Gross premium is a given number, we then need to calculate several subtotals based on a varying number of debits and credits (each premium can have one to...

Thanks HiTechCoach, Great resource, this is exactly what I am trying to accomplish. LAM

Hope it is okay to jump in to this thread. I am having the exact issue of trying to relate one company with another company. One example is a parent company that can have many child companies. I need to show the two companies and how they are related, Company 1 is the Parent Company, Company 2...

That may accomplish what I want, I'll give that a try. By the way, I do only have one company table, my affiliates table is your companyrelationships table, I shouldn't have changed the name in my example. Thank you very much your input has been helpful. LAM

Kryst51, I have created the three tables: tblCompany CompanyID (PK) CompanyType AffiliateID (FK) CompanyName Address (etc.) tblAffiliate AffiliateID (PK) tblContacts ContactID (PK) CompanyID (FK) ContactType Name Phone (etc.) So companies that share an affiliate Id are related...

Thanks again Kryst51, this gives me something to work on. I'll create the tables and relationships so I can try it in practice.

I can see the logic in that, still a little unclear as to how the relationship table is joined to the other two tables. Maybe it will be more clear if I actually set up the tables and can see the relationships. Another question, would I then also create other tables to handle information that...

Can a contact belong to both a client and an affiliate... We typically associate a contact with just one company. In the case of a parent company the contact would need to be associated with all the affiliated companies. Can an affiliate and it's parent company both be clients.. The actual...

In this case should I have two separate company tables? I need to associate some companies with other companies can I do this in the same table? Here are some scenarios Company A is our client, but is affiliated with Company B Company C has a Sister Company that may or may not be our client...