 | | From: | Moses Hanna | | Subject: | Set relation | | Date: | Mon, 17 Jan 2005 19:46:43 +1100 |
|
|
 | Hi
I want to create a datamodule containing two tables. A parent table has a
date field and a child table has date field and time field. I want to set
relation between the parent and the child on and index of date and time in
the child table. I had done that in VDB 5.7 by using expression index and
set exact off in the .QBE file. in dbase plus, how can we do that. Can
anybody Show me please
Moses
|
|
| | From: | Steve Hawkins | | Subject: | Re: Set relation | | Date: | Mon, 17 Jan 2005 08:24:09 -0500 |
|
|
| I'm assuming that you are talking about relating only to the date field of
the parent table here....
parent rowset index = dtos(parentdate)
child rowset index = dtos(childate)+timefield
Child table masterrowset = parent rowset
Child table masterfield = parentdate field
Look at MasterRowset and MasterField in online help for further
explanation. It's fairly easy to do.
There is also a pretty decent example of this in the Help | Knowledgebase
section of dBASE. Go to the Intermediate section and open the article on
Code Tips, Tricks and Advice. Go to the section on Relating Tables. Hope
this helps.
Moses Hanna said...
> I want to set
> relation between the parent and the child on and index of date and time in
> the child table. I
--
Steve Hawkins
Web site: sehawk dot com/db2K
Charter Member #219 / running Gravity 2.2 in Michigan
There are 10 kinds of people in the world...
those who get binary and those who don't.
|
|
