How do i??

[jaimielan]

Hopefully I am in the right forum. At present I don't know if it is a layout issue, field definition problem but I suspect that it has something to do with the defined relationship.

I have a database with two tables. A Main table and a categories table. In the categories table, I only have two fields,"Cat #" and "Description." I use these as a pop-up fields in the Data Entry layout.

I also run a summary report that takes all the values for the month and lists them. The only problem is that only the "Cat#" field is displayed on the report and not the "Description." I need for the Description to be automatically show up for the number that is displayed in "Cat#."

Can this be done?

Thanks for your help.

[Rob 7 Collins]

your report is generated from the main table? you should be able to do it:

(please pardon if these instructions are far, far too elementary -- better to be clear-er than confusing ... it's all the more embarassing because I don't know if this is your issue, just a guess)

1 ensure you have a relation between the main table and the category table based on cat# (go to File->Define->Database, the Relationships tab. drag from the main table's cat# field to the category table's cat#).

2. go to the report, layout mode

3. drag and drop to make room in the report for the description, I'll assume right after the cat#

3. drag a field onto the report's body, drop it after the cat#

4. FMP will prompt you to define the field ... in the top drop down box, select the category table. the list of available fields now shows the fields in teh category table, select the description field

that's it. switch to preview mode to see it it worked.