?
Solved

Master-Detail with dbase tables

Posted on 1997-08-05
1
Medium Priority
?
311 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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

[Webinar] Lessons on Recovering from Petya

Skyport is working hard to help customers recover from recent attacks, like the Petya worm. This work has brought to light some important lessons. New malware attacks like this can take down your entire environment. Learn from others mistakes on how to prevent Petya like worms.

Question has a verified solution.

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

Lync meeting or Lync conferencing is what many organizations would like to deploy to allow them save money. But companies are now giving up for various reasons, one of which is that they cannot join external meetings (non-federated company meetings)…
Ever visit a website where you spotted a really cool looking Font, yet couldn't figure out which font family it belonged to, or how to get a copy of it for your own use? This article explains the process of doing exactly that, as well as showing how…
The viewer will learn how to simulate a series of coin tosses with the rand() function and learn how to make these “tosses” depend on a predetermined probability. Flipping Coins in Excel: Enter =RAND() into cell A2: Recalculate the random variable…
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…
Suggested Courses

650 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