Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

Master-Detail with dbase tables

Posted on 1997-08-05
1
Medium Priority
?
315 Views
Last Modified: 2013-11-24
I have two dbase tables. One is the master table with two fields as index (i.e. client;work) and the other is the detail table with also the previous two fields as index. Th problem is that I can't find a way to connect this tables as  master-detail via this two key fields. I did this before but just with one field as index and it worked, but when I try to do it with the Field Link Designer I only can connect one field. If I set the MasterFields property to 'CLIENT;WORK' and then I firs open the master table and then the detail I get a 'Field index out of range' error. Please, I need help!

Thanks in advance
0
Comment
Question by:sime
1 Comment
 
LVL 2

Accepted Solution

by:
icampbe1 earned 200 total points
ID: 1340571
Although the documentation 'suggests' that you can, you really can't use two separate index fields like that.  You can however, create a dbase expression index using the combined fields (as long as they are character or string type).. this works but I'm not sure it will achieve exactly what you want.  
Another way to go, is to use one of the index fields for the master/slave relationship, and then use the 'OnFilterRecord' event to qualify the records on the other index.  This works as well.
Finally, you could use a Paradox table.

Cheers,
Ian C.
0

Featured Post

NEW Veeam Backup for Microsoft Office 365 1.5

With Office 365, it’s your data and your responsibility to protect it. NEW Veeam Backup for Microsoft Office 365 eliminates the risk of losing access to your Office 365 data.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

User Beware!  This is a rather permanent solution to removing your email from an exchange server.  The only way to truly go back is to have your exchange administrator restore your mailbox from backups.  This is usually the option of last resort.  A…
When you see single cell contains number and text, and you have to get any date out of it seems like cracking our heads.
The viewer will learn how to use a discrete random variable to simulate the return on an investment over a period of years, create a Monte Carlo simulation using the discrete random variable, and create a graph to represent the possible returns over…
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …
Suggested Courses

578 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question