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.

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