Hi all,

I am using a button with the Action “Open Form Related” and simply need to know what to put in the action Parameters to open a different form that uses the related table but does not define the related table.

In other words the attached pic shows what works in DE65 but I can’t seem to get it to work in DE72. In this example I am using a form called Makes which is relate to a sub-form called Models. I need the action button to open a form called ModelsSF and not the default form Models. Hope this makes sense. Your help would be greatly appreciated.

You have done it right. Just make sure there is no misspellings etc in the form name.

I have had this problem before when the form was saved with a leading blank.

Try to save a copy of the form and make sure there is no leading blanks and then try again.

Thanks for your reply.

I was wondering if there is any more information or examples in the designers guide. I can’t seem to find detailed information in any of the manuals I have.

Hi.

In my mind DataEase Manuals has never been up to scracth. It is to much about all the stuff that you don't need to be told and too little about the "juicy" stuff.

It has been like this sin 1.x

Manuals is obviously a thing of the past and for the next main release of DataEase we are working on a help website with interactive samples, ideas, how to as well as templates to be used as a basis for your new system as well as functional templates that can be used as plugins in existing systems.

Throughout the development of 8.x we have published samples and written articles/blog about all the new features and how to use them.

Sadly these don't work in 7.x

If you don't have the 7.x Designers Guide you find it here
http://www.dataease.com/static/help/DG/DG.htm

A special thanks for replying to my post. I appreciate it.

I did however figure out what I was doing wrong. I forgot I needed to set up a relationship between the subform and itself with “SeeRecord” in the options field. Attached is the example in case anyone else encounters this problem.

Thanks again..

Yes, we sometimes forget to ask the "obvious" question.

Everything in DataEase is based on a relationship.

You think you are opening a form but in reality you open a "Relationship" or a query. 

A relationship defined in the Relationship table is just a definition that is being used "ad-hoc" to define the underlying multi-virew.

DataEase Multi-Views are very advanced and extreemly flexible.

Every time you do a search in a form you create a NEW Multi-view that only include the data that you have requested and the multi-view is also impacted by what is on screen (what fields you see) and what fields they reference etc.

In DataEase Forms the Multi-view in many ways are underutilised as you restricted very much by the design of the form when in reality it can be completely free.

This we take advantage of in ExecDQL which is compiled and fired on the go and the code can in fact be a result of another DQL/script etc.

any in DQL is the same as Lookup in Forms with one big difference which is that you can define the relationship on the fly.

But as everyting in actually a relationship and DataEase suggest that the first relationship between two tables are named after the tables you need to be aware that you actually use a relationship if it is defined and if not DataEase will create on ad-hoc.

define "mycount" number .

for Customers ;
etc.
etc.
mycount := count of CustomerContact .

if there is a relationship between Customers and CustomerContact (with no relationship name) this really means that you count the number of occurences inn that relationship.

So for instance if you want to get all customer contacts with a particular code you need to do it like this.

define "mycount" number .

for Customers ;
etc.
etc.
mycount := count of named  CustomerContact  named "MyRel1" with Code="AL" .