Can't make relationship work

[categoryman]

I can't get data from two tables to display.

Any insight into what I am doing wrong here?

Attached are two screen shots that will hopefully make what I have done clear.

Shot 1 shows two simple tables, and how the primary and foreign keys were set up.

Shot 2 shows how the relationship was set up, three layouts (table 1, table 2, and a combination of the two) and the "result" that only shows data from table one.

Thanks you for your help.

[Ersen Kavak]

Hi,

If you want to create new record in note details related to anote, than I would recommend checking the "create new records in this table via this relationship" checkbox under "notedetails" table, and then insert a portal which shows records from notedetails, in a layout of "notes" table...

cheers