FSGROUP
Full Member
  Offline
 No personal text
Posts: 179
Location: Edmonton, Alberta, Canada
Joined: Jan 14 th, 2004
|
Re: exporting multiple databases
Reply #2 - Jan 21st, 2004 at 9:56pm
|
Print Post
|
I am trying to translate an application from Q&A into Sesame, however the Q&A application was simply one huge and ugly database, where redundant field names existed. For example, if a client had multiple insurance policies then there would exist fields such as PolicyNo1, PolicyType1, PolicyAmount1, PolicyNo2, PolicyType2, PolicyAmount2, etc.., which is a poor design.
It makes sense to me to split this database into several databases: one for Client Info(address, name, etc), one for Policies(number, type, amount, etc), one for Children(name, DOB), etc.. Correct?
But the problem is that I cannot incorporate the various info from the databases together. Say, I want to create a report where I can display all the children and policies belonging to a particular client. A client can have several policies and children, so is there any way to combine the three databases, joining them by a client ID?
Also, I would like to do a mail merge where (for example)I can display all the policies for a client and his birthday and address. How do I export data from multiple tables?
Maybe I'm missing something because there *should* be a method to combine data from several tables allowing me to create reports and whatnot without having one gigantic database and redundant fields?
Thanx a bunch
|