i have two tables that are linked [relatipnship] and i'm showing their data on two different layouts. on one layout user can enter the data but on 2nd layout i'm using two portals to display entered data from the two tables. however, portal is showing a blank row at the bottom for new record but i want to hide/remove it. the relationship between the two tables is to allow addition/creation of new records but thats only for layout 1 where user can add a new customer thus adding info to related table as well. but in portals [layout two] i don't want to have new record blank row.

i know i can do that by removing the option through relationship but then that will not allow me to add new records anywhere on any layout where these tables are placed.

so is there any way [with or without] script or any other way to eliminate the new record row in the portal on that layout only [note data is read only on this layout...]

Hi,

You will need two relations, one that allows creation, the other not. Same Table, same relation, with two separate occurrences, both with different options selected.

There are workarounds so that even if the option is set to allow creation, one could only enter this new row through a script. But, workarounds...

thanx for the quick reply.

lets say i create TO of both tables with same relationships but without create-new-record option. how about the data? original tables will have data entered by the user but will these TO have the data copied to them automatically or no? if yes then my problem is solved. if not then 50% solved and 50% left.

They are table [color:red]occurances, not tables. You are looking at the exact same table that contains the data.

thank you so very much to both of you for your replies and help. greatly appreciated.