Jump to content
Sign in to follow this  
Orchid28

Can't input any data

Recommended Posts

I don't know what I did wrong but I can't input any new data iinto any of my records. Whenever I click into a box to add in new information about a project that is in progress it won't let me type into it. I am in Browse mode so I don't know why its limiting me.

Share this post


Link to post
Share on other sites

Are these new records or records that are already committed?

Share this post


Link to post
Share on other sites

Check the field formatting and make sure the field entry in browse mode is selected.

Can you create new records? If not then check whether the file is locked, or whether it is on a locked volume.

Share this post


Link to post
Share on other sites

Well some fields I have data in it and I am able to edit and add data to it and the fields that dont have data (its just a blank white space) I can't input anything into it.

Share this post


Link to post
Share on other sites

Another possible cause ... maybe those non-enterable fields are actually related RECORD'S fields and 'allow creation' in the graph is not on, in which case you can type into fields when there is already a relationship but are prohibited when not.

Share this post


Link to post
Share on other sites

Yes I think it has something to do with the relationships between the tables I have. There are 3 tables and Table 1 is my main table and I am able to edit the fields. But Table 2 and Table 3 I can not add any data to the blank fields. I don't know what I did wrong with the relationships between the tables though. When I remove the relationship graphs the empty fields on Table 2 and 3 says <unrelated table>.

Any suggestions?

Share this post


Link to post
Share on other sites

Sure, when you delete a table occurrence, any fields which reference it will no longer be related to your layout. I could tell you to turn on 'allow creation' in the graph (which I mentioned before) but if table 2 or 3 are the 'many' side of this relationship, allowing creation if they are FIELDS on the layout instead of portal will not allow multiple record selection.

We need to know what those relationships had represented. I suggest you create an empty clone File > Save Copy As ... zip it and attach it. :^)

Share this post


Link to post
Share on other sites

Well here is what I have. I am not too familiar with how relationships work so I'm not sure if I am doing this correctly. The BIA table is the main table. I will need to input data into the Control table and the Definitions table.

The definitions table is just a reference table of what each field means

The Control table is basically an expansion of the BIA Table

When I am in browse mode I am unable to add data to the empty fields in both the Definitions and Control tables. I can only input data in the fields that already have data in it.

Document1.doc

Share this post


Link to post
Share on other sites

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 account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

×

Important Information

By using this site, you agree to our Terms of Use.