We'd need to know a lot more about what you have and what you have done before we coud tell you how and why that happened. I doubt your database is destroyed.
Try creating a brand new layout based on the table that "isn't working". See if you can enter data on this new layout.
If you can do that report back and we'll take a closer look at your original layout where you are unable to edit data.
Thanks for the response :)
I have created a new layout, and can edit and input data now. Also, when the data is edited in the new layout... it also updates the layout that isnt working.
does this give you a better idea?
Both layouts refer to the same table so changes to the data will appear on both layouts. Now we can compare the two layouts to see what is different in order to see why the original layout is preventing you from editing data on it.
What is keeping you from editing data on the original layout? Do you get error messages when you try to change data? Are you unable to enter the fields?
Enter layout mode and pull up layout setup... What text is currently selected in the "show records from" drop down?
You can also capture a screen shot of your layout while it is in layout mode and upload that image as part of your next post here.
When i try to enter data, i simply cant click on the field.
Here is a photo of my layout mode, and the layout set up:
While in layout mode select one of the fields that you cannot enter by clicking it. Check behavior section of the inspector's data tab. Is the Browse Mode box selected in the Field Entry section?
If it is not selected it should be if you plan to edit/enter data in that field on your current layout.
Fixed! Thank you so much :)