Limitations with IWP for 2 tables

[agtjazz]

Hello,

I have a form that have fields from 2 tables... like tbl:people (name, email etc) and tbl:request (request details).

It seems IWP doesn't do this on 1 layout... unless I am doing something completely incorrect (which I am kinda hoping it's that).

Any advice?

[UpNorth]

I know I have a database with multiple tables and I have a layout with multiple fields from multiple tables, so it can be done we just have to figure out what your issue is.

So.. have you placed the fields on your layout? and if yes does it have data in it when you view it not from iwp?

Edited January 23, 2008 by Guest

[agtjazz]

Thanks for the response. I think it's with the relationship. If a new person adds a request, it's ok. If a person who exists in the db, adds another request it gives an error about related records.

I will keep fiddling

Thanks again