TnewmanP10 Posted November 6, 2007 Posted November 6, 2007 My database was originally set up to permit the user to enter data into portals on the first page. All was well. : Now, after adding some additional portals for the same purpose, I cannot enter data into the new portals. I cannot click on the fields in the portal, nor can I tab to them. The fields simply will not accept entries. I set them up just like the originals that function fine, but the new ones are not functioning the same. Can anyone help?
bcooney Posted November 7, 2007 Posted November 7, 2007 Two things to check: 1. You have "Allow Creation of Related Records" on in the relationship (Edit Relationship on the Graph). 2. You have field behavior to allow entry in Browse Mode.
TnewmanP10 Posted November 8, 2007 Author Posted November 8, 2007 I appreciate the answer! Thanks. But, the portals I had created before are not set to create related records--and yet they allow me to. So, it doesn't make sense that the new portals I am creating opperate differently. Field behavior is set to allow entry in Browse Mode also. Can you think of anything else that might be tripping me up? Tammy [color:blue]Two things to check: 1. You have "Allow Creation of Related Records" on in the relationship (Edit Relationship on the Graph). 2. You have field behavior to allow entry in Browse Mode.
bcooney Posted November 8, 2007 Posted November 8, 2007 But, the portals I had created before are not set to create related records--and yet they allow me to. Can't be. You can only create records in a portal if the table occurrence that the portal is based has "Allow Create" in its relationship. Please post a clone.
TnewmanP10 Posted November 8, 2007 Author Posted November 8, 2007 [color:gray]Please post a clone. Will do on Monday--is that okay? I currently am traveling and can't get access to the in-house server where DB is hosted. Thanks much!
TnewmanP10 Posted November 13, 2007 Author Posted November 13, 2007 Attached is an archive file of my DB. Account Name: Admin Password: 2727 When you toggle between the two blue tabs on first page you will see the old portals which do allow me to enter data (NCAA History), and the new portals which do not (New Gov History). Thanks, Tammy _Clone.fp7.zip
FestiveEmbalmer Posted November 13, 2007 Posted November 13, 2007 I appreciate the answer! Thanks. But, the portals I had created before are not set to create related records--and yet they allow me to. So, it doesn't make sense that the new portals I am creating opperate differently. Actually, the relationships between the TOs that your old portals represent do have "Allow creation" on, while the new ones do not. I turned on allow creation in each TO under "New Governance" and they allow entry. shalom, Matthew
TnewmanP10 Posted November 13, 2007 Author Posted November 13, 2007 Thanks Matthew. Then I guess I do not know where to set to allow creation. Is it in the Relationships Table? Tammy
FestiveEmbalmer Posted November 13, 2007 Posted November 13, 2007 exactly. In define database under relationships. Just double-click on the join symbol (or even just the line)between two tables. The logic follows that you will want to allow creation on the many side of the relationship and you will need to decide if you want to automate deletion when a parent record is deleted. You don't want to have orphaned records but you also may not want to be able to wipe out your data with cascading deletes across all your tables. That all depends on your business logic.
TnewmanP10 Posted November 13, 2007 Author Posted November 13, 2007 Thanks so much! Appreciate your help. Have a great week! Tammy
Recommended Posts
This topic is 6278 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