Browsing Relations

[ShortyII]

I Have the following question.
When you open a table you can use a BROWSE:
Select("customer&quot
Browse All

And you see all fields with the data from this table


Now i have a relation between two tables:
SET ORDER TO TAG Recnr OF "building.cdx" IN building
SET RELATION TO customer.Recnr INTO building ADDITIVE

Now i want to exit a browse over the two tables so i can see all fields and data from both tables.

Anyone

 

[wgcs]

do this:

SELECT Building
BROWSE NORMAL
* Click on the Command window
SELECT Customer
BROWSE NORMAL

Now, when you move the record pointer in the Customer browse window, you'll see only the related records in the Building browse window.

Alternatively, you could construct a browse FIELDS clause like:

BROWSE NORMAL FIELDS Customer.Recnr,Customer.name,Building.Recnr, building.name, etc.

this will show the date from only the first related record in the building table.

I recommend using BROWSE like this only for developement/debugging, not for the real UI in your app: Grids are much easier to make user-friendly...

 

[ShortyII]

Great option
Super Thanx