Liveware Publishing Support Forum

Hello,____I am kind of confused by lookups in report writer 9.0. There is a report at my company that uses stock.dbf as the Master table in MOM. This report just displays info from stock.dbf such as stock number, description, units on hand, etc. After looking through all of these fields I figured that there wouldn^t be any relationships for this report, but there are actually 2 exact lookup relationships.__The first relationship does the following.____Relate From__ Table: STOCK__ Field: DISTRIB____Relate To__ Table: SUPPLIER.DBF__ Alias: SUPPLIER____Relate Through__ Index: SUPPLIER.CDX__ Tag: CODE__ Key: code____The second relationship does the following.____Relate From__ Table: STOCK__ Field: NUMBER____Relate To__ Table: PRICE.DBF__ Alias: PRICE____Relate Through__ Index: PRICE.CDX__ Tag: NUMBER__ Key: number____I am really confused on why the relationships are required. I guess I can kinda understand needing one but not two. The help file with Report Writer does not go into much detail at all on relationships. __Could someone please help me out?____Thanks,____malaize

You may want to print your report specifications so that you can see all of the fields that are used in the report. Or you can try deleting the relations to see what impact they might have.____Kathleen__R&R Support

>You may want to print your report specifications so that you __>can see all of the fields that are used in the report. Or __>you can try deleting the relations to see what impact they __>might have. __>__>Kathleen __>R&R Support ______Thank you for the reply,____The report specifications are pretty handy. ____I deleted the relationships and the report still ran the same. Maybe the guy who created that report was planning on adding something to the report.____So if you have one table in a report that is designated as the Master Table and you want to include a field in the report that is from another table you would use an exact lookup to "link?" to that field in the second table? Hope that is not too confusing, just trying to make sense of it all.____Thanks for the help,____Eli

An exact lookup is used when there is a 1 to 1 relation between tables. A scan relation type is used when there is a 1 to many relation.____Kathleen__R&R Support

So the 1 to 1 relation between fields mean that the same field exists in both tables?____Thanks, eli

The field names can be different but their contents would be the same.____Kathleen__R&R Support