dervaish Posted May 7, 2008 Posted May 7, 2008 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...]
Ugo DI LUCA Posted May 7, 2008 Posted May 7, 2008 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...
dervaish Posted May 7, 2008 Author Posted May 7, 2008 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.
Ano Nimus Posted May 8, 2008 Posted May 8, 2008 They are table [color:red]occurances, not tables. You are looking at the exact same table that contains the data.
dervaish Posted May 8, 2008 Author Posted May 8, 2008 thank you so very much to both of you for your replies and help. greatly appreciated.
Recommended Posts
This topic is 6381 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now